Previous Topic Next topic Print topic


REC_DELIMITER

Restriction: This topic applies to Windows environments only.

Specifies the end-of-record delimiter used to separate records in modified free-format ASCII files. 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 Import command is required for every transaction when importing free-format ASCII files into 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