DELIMITED format

In this format, unload data files are in a delimited format.

Important

The UNLOAD command supports unloading data files in a delimited format only.

Related topic

Output-file-formats 

When data is in a delimited format:

  • All fields in the input data set are character strings or external numeric values
  • Each column in a delimited file is separated from the next column by a column delimiter character

For each of the delimiter types that you can specify, you must ensure that the delimiter character is specified in the code page of the source data. You can specify the delimiter character as either a character or hexadecimal constant. You can specify either COLDEL '#' or COLDEL X'23'. For Unicode and ASCII encodings, you should specify the delimiter character in the utility statement as a hexadecimal constant, or the result can be unpredictable.

You can use the following delimiters with FORMAT(DELIMITED) on the UNLD command. For more information, see UNLD-FORMAT.

  • COLDEL specifies the column delimiter that is used in the unload file.
  • CHARDEL specifies the character string delimiter that is used in the unload file.
  • DECPT specifies the decimal point character that is used in the unload file.

You cannot specify the same character for more than one type of delimiter.


 

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