VARCHAR
VARCHAR defines a character string field that varies in length.
For more information, see Additional-variable-field-considerations.
MIXED
MIXED defines a mixed character field.
FILL
FILL tells UNLOAD PLUS how to handle leading zeros when converting data from a source with numeric data types. This capability supports applications such as COBOL that require leading zeros in order to edit and check unloaded data properly.
YES | When you specify FILL YES, UNLOAD PLUS externalizes all leading zeros when converting numeric data types to their external representations. The first character in the external representation of the number is either a minus sign (-) or a plus sign (+). This capability supports applications such as COBOL that require leading zeros in order to edit and check unloaded data properly. |
---|---|
NO | When you specify FILL NO, UNLOAD PLUS removes all leading zeros when converting numeric data types to their external representations. |
BLOBF
BLOBF defines a field that contains the name of a binary large object (BLOB) file to which you are unloading LOB data. You must specify the name of the output descriptor that you defined in your OUTPUT statement for this file. For more information, see the description of the OUTPUT option.
UNLOAD PLUS ignores this field specification if you specify SPANNED YES.
BINARYXML | This option is valid only when DIRECT YES is in effect. BINARYXML indicates that you are unloading XML data to the BLOB file. When generating LOAD control cards, UNLOAD PLUS adds the BINARYXML option to the field specification for the XML column. |
---|
CLOBF
CLOBF defines a field that contains the name of a character large object (CLOB) file to which you are unloading LOB or XML data. You must specify the name of the output descriptor that you defined in your OUTPUT statement for this file. For more information, see the description of the OUTPUT option.
UNLOAD PLUS ignores this field specification if you specify SPANNED YES.
DBCLOBF
DBCLOBF defines a field that contains the name of a double-byte character large object (DBCLOB) file to which you are unloading LOB data. You must specify the name of the output descriptor that you defined in your OUTPUT statement for this file. For more information, see the description of the OUTPUT option.
Restrictions
The following restrictions apply to the DBCLOBF field specification:
- You cannot unload XML data to a DBCLOB file.
- UNLOAD PLUS ignores this field specification if you specify SPANNED YES.
(length)
The length indicates the number of single-byte characters. A 2-byte length field that contains the length of the character string in bytes precedes the VARCHAR string. This length does not include the two length bytes. For calculating length when converting from a numeric column, see Supported-data-type-conversions.
When used with the BLOBF, CLOBF, or DBCLOBF subtype, the length specifies the size of the expanded output descriptor name in bytes. Note the following considerations with these subtypes:
- If you specify a length that is less than the size of the expanded output descriptor name, UNLOAD PLUS terminates.
- If you do not specify a length, UNLOAD PLUS defaults to the following values:
- 54 for DSNTYPE=PDS or DSNTYPE=LIBRARY
- 255 for DSNTYPE=HFS
TRIM | TRIM tells UNLOAD PLUS to remove as many trailing blanks from the string as needed to make the string length match the length that you specify. If the string is still too long, a conversion error occurs. UNLOAD PLUS applies TRIM before TRUNCATE. TRIM is useful when you are converting from a VARCHAR column to a CHAR(n) or VARCHAR(n) field and you want to detect (by way of conversion error messages) nonblank data beyond position n. Restrictions UNLOAD PLUS ignores the TRIM option in either of the following cases:
|
---|
TRUNCATE
TRUNCATE tells UNLOAD PLUS to truncate a string if it is longer than the field (even after the TRIM option has truncated trailing blanks). UNLOAD PLUS performs TRUNCATE after TRIM.
UNLOAD PLUS ignores TRUNCATE for BLOBF, CLOBF, and DBCLOBF subtypes.
Related topic