Previous Topic Next topic Print topic


REC_DELIMITER

Specifies the delimiter for free-format ASCII export types. The syntax is:

REC_DELIMITER = {'xx' | "<ascii>"};

where:

xx is a character string delimiter
ascii is an ASCII decimal code.

The angled brackets around the ASCII code are required. The default delimiter is a space character (ASCII code <032>).

The end-of-record delimiter can be specified as a character string or in ASCII decimal notation. If the delimiter is specified in ASCII decimal notation, enclose each ASCII code in angled brackets. For example, to use the decimal notation for a semicolon, enter the string <059>.

The delimiter cannot be a character found within the data values unless the values are enclosed in quotes. The most common record delimiter found in ASCII files is a carriage-return, followed by a line-feed.

The REC_DELIMITER Batch Export command is required for every transaction when exporting Free ASCII files to XDB Server.

For example:

REC_DELIMITER = "<013><010>";

sets the record delimiter to a carriage-return/line-feed combination.

Previous Topic Next topic Print topic