DOUBLE DELIM
Use the DOUBLE DELIM option to specify the option to double the delimiters into the string values in DEL or DELIMITED formats.
- DOUBLE DELIM
- If this option is set to ON, the character type columns (CHAR, VARCHAR, LONGVARCHAR, CLOB,
GRAPHIC, VARGRAPHIC, LONG VARGRAPHIC or DBCLOB) and the binary type columns (BINARY,
VARBINARY or BLOB) are scanned for occurrences of the delimiter, and each discovered
occurrence is doubled. If set to BINARY, then only character columns that have FOR BIT
DATA and binary columns are scanned. If set to OFF, then no scanning occurs. The
delimiter is subject to the restrictions described in "Delimiter restrictions for the
export" in the Db2® Data Movement Utilities
Guide and Reference (SC09-4830).
You can achieve the best performance by doing as little scanning as possible. You might be able to avoid scanning character columns by selecting a character to use as a delimiter that you know is not used in the unloaded data. If you cannot use a character that is not used in unloaded data, then set the DOUBLE DELIM option to ON in the control files where necessary. If you anticipate that your users will not set the DOUBLE DELIM option to ON where required, you can set it in the configuration file. The user can override whichever setting is made here in their individual control files.
Attention: If you unload a FOR BIT DATA character column or a binary column, DOUBLE DELIM must be set to either BINARY (default) or ON. Another consideration exists when unloading a FOR BIT DATA character column or a binary column containing a row delimiter: when running Db2 LOAD, you must specify the clause:For more information about LOAD command options, refer to Db2 documentation.modified by delprioritychar. - Syntax
DOUBLE DELIM BINARY | ON | OFF- Variable
- None.
- Default
- BINARY
You can override the default by setting
DOUBLEDELIMto ON or OFF in the db2hpu.cfg file.