+CHARFLDDLM


Use this parameter to override the default field delimiter characters used for character data fields when unloading using ASCIIDEL-format.


image-2023-11-15_12-5-51.png

The default delimiter for character data is double quotation marks ("). You can use most single characters as a delimiter except a plus sign, comma, or blank. You can also use a null character (that is, no character at all). To do this, code as +CHARFLDDLM(), with no operand.

The UNLD command option FORMAT ASCIIDEL CHARFLDDLM overrides this parameter. For more information, see UNLD-FORMAT.

Operands

delim

Single character representing the character field delimiter

You can specify that the delimiter be null.

 In the following example, the character strings are not delimited:

+CHARFLDDLM()

In the following example, the character strings are delimited with a period:

+CHARFLDDLM(.)

Important

For the rules that apply to parameter syntax, see Parameter syntax rules.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*