TEMP_EXTRACT_ROW_DELIMITER option

Specifies the delimiter between rows in the output of the data extraction facility for an ASCII extraction.

string

Can be set for an individual connection. Takes effect immediately.

'' (the empty string)

This option specifies the delimiter between rows in the output of the data extraction facility. In the case of an ASCII extraction, the default is to end the row with a newline on UNIX platforms and with a carriage return/newline pair on Windows platforms.

The delimiter must occupy from 1 to a maximum of 4 bytes and must be valid in the collation order you are using, if you are using a multibyte collation order. Be sure to choose a delimiter that does not occur in any of the data output strings themselves. Note that the default for the TEMP_EXTRACT_ROW_DELIMITER option is the empty string. IQ converts the empty string default for this option to the newline on UNIX platforms and to the carriage return/newline pair on Windows platforms.