NULLCHAR
With the exception of the HIVAL option, the values that you specify for the NULLCHAR option signify only a single byte. If the null indicator field is two bytes long, UNLOAD PLUS propagates the constant to the second byte. The following table describes the values that you can specify for this option:
Value | Description |
|---|---|
? | This value tells UNLOAD PLUS to fill the null indicator field with the question mark character, '?'. |
HIVAL | This value tells UNLOAD PLUS to fill the null indicator field with high values. |
'c' | This value tells UNLOAD PLUS to fill the null indicator field with the character c, where c is any constant that is valid for C-type assembler language. |
X'xx' | This value tells UNLOAD PLUS to fill the null indicator field with xx, where xx is any valid hexadecimal assembler constant, except X'00'. |
Restrictions
Note the following restrictions when using the NULLCHAR option:
- If you specify FORMAT DSNTIAUL, UNLOAD PLUS overrides this value to '?'.
- UNLOAD PLUS ignores this option if you also specify FORMAT BMCLOAD.
- When you are using the CNTLCARDS SQL/DS, SQL/DS-DDL, or SQL/DS-LOAD options, the only valid specification for NULLCHAR is ?. If you try to use any other NULLCHAR value, UNLOAD PLUS issues message BMC51610E and terminates.
Specifying the default
You can specify the default for the NULLCHAR command option in your installation options module by using the NULLCHAR installation option. UNLOAD PLUS was shipped with a default value of ? for this option. The command option overrides the default that is in the installation options module.