Specifies the symbol that separates loaded and unloaded files in the LOAD and UNLOAD statements.
Syntax:
DBDELIMITER={delimiter}
Possible values:
Variable value can be any single character except for:
§ hexadecimal digits (0 through 9, a through f, and A through F),
§ newline character (or Ctrl + J),
§ \ (backslash).
| by default.
Usage and examples:
Separators are necessary when you load data to or unload it from the database statement by means of the LOAD and UNLOAD statements.
You can specify this separator by
§ setting the DBDELIMITER value (^, caret, becomes the delimiter in the example):
DBDELIMITER=^
§ adding the DELIMITER clause to the LOAD or UNLOAD statement,
§ using the base.Channel.setDelimiter() method.
If DBDELIMITER is not set and the DELIMITER clause is omitted, the default delimiter - |, pipe, - is used.
DBDELIMITER applies at runtime, so it must be set in inet.env.
Related articles: