DBDELIMITER

Specifies the symbol that separates loaded and unloaded files in the LOAD and UNLOAD statements.

Syntax

DBDELIMITER={character}

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 is set in inet.env.