VARCHAR
VARCHAR defines a varying-length character string.
MIXED
MIXED defines a mixed character data field. You can specify MIXED as either a subtype itself or with the CLOBF subtype.
BLOBF
BLOBF indicates that the field contains the name of a binary large object (BLOB) file that you are loading into a LOB or XML column.
When loading CLOB or DBCLOB data from a BLOB file, LOADPLUS invokes DSNUTILB.
Option | Description |
---|---|
PRESERVE WHITESPACE | PRESERVE WHITESPACE preserves the white space in the BLOB file when loading into an XML column. |
BINARYXML | BINARYXML indicates that the referenced file contains binary XML data. If you also specify the AVGSIZE keyword, you must specify it after BINARYXML. |
AVGSIZE | This option provides an estimate of the size of the input data. Specify a number, optionally followed by the unit of measure (K, M, or G). The minimum value that you can specify is 1K. The maximum value that you can specify is 2G, 2048M, or 2097152K. The default unit of measure is K. Alternatively (for LOB input), you can specify a global value with the LOBAVGPCT command or installation option. The AVGSIZE field specification overrides the LOBAVGPCT option. |
DBCLOBF
DBCLOBF indicates that the field contains the name of a double-byte character large object (DBCLOB) file that you are loading into a LOB or XML column.
When loading XML, CLOB, or BLOB data from a DBCLOB file, LOADPLUS invokes DSNUTILB.
Option | Description |
---|---|
PRESERVE WHITESPACE | PRESERVE WHITESPACE preserves the white space in the DBCLOB file when loading into an XML column. |
AVGSIZE | This option provides an estimate of the size, in bytes, of the input data. Specify a number, optionally followed by the unit of measure (K, M, or G). The minimum value that you can specify is 1K. The maximum value that you can specify is 2G, 2048M, or 2097152K. The default unit of measure is K. Alternatively (for LOB input), you can specify a global value with the LOBAVGPCT command or installation option. The AVGSIZE field specification overrides the LOBAVGPCT option. This option is not valid for XML input. |
CLOBF
CLOBF indicates that the field contains the name of a character large object (CLOB) file that you are loading into a LOB or XML column.
When loading DBCLOB or BLOB data from a CLOB file, LOADPLUS invokes DSNUTILB.
Option | Description |
---|---|
PRESERVE WHITESPACE | PRESERVE WHITESPACE tells LOADPLUS to preserve the white space in the CLOB file when loading into an XML column. |
AVGSIZE | This option provides an estimate of the size of the input data. Specify a number, optionally followed by the unit of measure (K, M, or G). The minimum value that you can specify is 1K. The maximum value that you can specify is 2G, 2048M, or 2097152K. The default unit of measure is K. Alternatively, for LOB input, you can specify a global value with the LOBAVGPCT command or installation option. For XML input, you can specify a global value with the XMLAVGSIZE command or installation option. The AVGSIZE field specification overrides the LOBAVGPCT and XMLAVGSIZE options. |
TRIM
TRIM truncates trailing blanks from the input string value before LOADPLUS attempts to assign the value to a CHAR or VARCHAR column. If the string is still too long, a conversion error occurs. LOADPLUS performs TRIM before TRUNCATE.
Additional considerations
The following considerations apply to the TRIM option for a VARCHAR field:
- For a DSNUTILB load, LOADPLUS translates this option to STRIP TRAILING ' ' before passing the field specification to DSNUTILB.
- TRIM is useful when converting from a VARCHAR field to a CHAR( n) or VARCHAR( n) column and you want to detect nonblank data beyond position n.
- If you are loading Unicode data and do not need to preserve trailing blanks, BMC strongly recommends that you specify TRIM. If translation causes an expansion of the data, specifying this option will prevent LOADPLUS from discarding records that you do not want to discard.
Restriction
This keyword is not valid with BLOBF, DBCLOBF, or CLOBF subtypes.
TRUNCATE
TRUNCATE truncates a string if it is longer than the column’s maximum length (after trimming). LOADPLUS performs TRUNCATE after TRIM.
When loading Unicode data, LOADPLUS performs truncation after translation.
Restriction
This keyword is not valid with BLOBF, DBCLOBF, or CLOBF subtypes.
Related topic