DBDELIMITER environment variable

Set the DBDELIMITER environment variable to specify the field delimiter used with the dbexport utility and with the LOAD and UNLOAD statements.


1  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 '+'