DBDELIMITER

The DBDELIMITER environment variable specifies the field delimiter used with the dbexport utility and with the LOAD and UNLOAD statements.

>>-setenv--DBDELIMITER--'delimiter'----------------------------><
 

delimiter

is the field delimiter for unloaded data files.

The delimiter can be any single character, except those in the following list:

• Hexadecimal digits (0 through 9, a through f, A through F)
• Newline or CTRL-J
• The backslash ( \ ) symbol

The vertical bar ( | = ASCII 124) is the default. To change the field delimiter to a plus ( + ) symbol, for example, you can set DBDELIMITER as follows:

setenv DBDELIMITER '+'