String

A single apostrophe (')

Controls the default string that begins and ends all strings in data exported to text 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 TEXT;

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.