TEMP_EXTRACT_ROW_DELIMITER option

Function

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.

See also

For details on the data extraction facility and using the extraction options, see “Data extraction options” in Chapter 7, “Moving Data In and Out of Databases” in the System Administration Guide: Volume 1.

“TEMP_EXTRACT_COLUMN_DELIMITER option”

“TEMP_EXTRACT_QUOTES option”

“TEMP_EXTRACT_QUOTES_ALL option”

“TEMP_EXTRACT_ROW_DELIMITER option”