TEMP_EXTRACT_ROW_DELIMITER Option

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

Allowed Values

String

Default

'' (the empty string)

Scope

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

Description

TEMP_EXTRACT_ROW_DELIMITER 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 1 – 4 bytes and must be valid in the collation order you are using, if you are using a multibyte collation order. Choose a delimiter that does not occur in any of the data output strings. The default for the TEMP_EXTRACT_ROW_DELIMITER option is the empty string. Sybase 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.

For details on the data extraction facility and using the extraction options, see System Administration Guide: Volume 1 > Data Import and Export > Methods of Exporting Data from a Database > Data Extraction Facility.

Related reference
TEMP_EXTRACT_COLUMN_DELIMITER Option
TEMP_EXTRACT_QUOTES Option
TEMP_EXTRACT_QUOTES_ALL Option