DBDELIMITER
Defines the value separator for unload data files.
The DBDELIMITER environment variable defines the character to delimit data field values for LOAD
/UNLOAD
instructions, and for the for the base.Channel
in/out API.
If DBDELIMITER is not defined, the default delimiter is a (|
) pipe.
Only one single character can be specified. When setting the DBDELIMITER environment variable with a string, only the first character is used.
Do not use backslash (\
), or hex digits (0-9
,
A-F
, a-f
). When using such character, the
LOAD
/UNLOAD
instructions will raise error -10099.
Note: Additional formatting options can be specified with the
DELIMITER
option of
LOAD
/UNLOAD
and the base.Channel.setDelimiter()
method.