Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

isql_quote option [Interactive SQL]

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

String

A single apostrophe (')

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.

• isql_field_separator option [Interactive SQL]
• SET OPTION statement [Interactive SQL]

To change the default string that begins and ends all strings to a double quote character.

SET OPTION isql_quote='"';
SELECT Surname, GivenName FROM Employees WHERE EmployeeID < 150;
OUTPUT TO c:\Employees.txt FORMAT ASCII;

This code places the following data in Employees.txt:

"Whitney", "Fran"

"Cobb","Matthew"

"Chin","Philip"

"Jordan","Julie"

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