ISQL_QUOTE option [Interactive SQL]

Function

Controls the default string that begins and ends all strings in data exported to ASCII files.

Allowed values

String

Default

A single apostrophe ( ' )

Description

Controls the default string that begins and ends all strings in data exported to ASCII files. If an OUTPUT statement does not contain a QUOTE clause, this value is used by default.

Example

To change the default string that begins and ends all strings to a double quote character.
```
SET TEMPORARY OPTION ISQL_QUOTE='"'; SELECT emp_lname, emp_fname FROM employee WHERE emp_id < 150; OUTPUT TO c:\employee.txt FORMAT ASCII
```
This code places the following data in employee.txt:

“Whitney”, “Fran”

“Cobb”,”Matthew”

“Chin”,”Philip”

“Jordan”,”Julie”

The separator characters (in this case, commas) depend on the ISQL_FIELD_SEPARATOR setting.