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

isql_field_separator option [Interactive SQL]

Controls the default string used for separating values in data exported to ASCII files.

String

A comma (,)

Controls the default string used for separating (or delimiting) values in data exported to ASCII files. If an OUTPUT statement does not contain a DELIMITED BY clause, the value of this setting is used.

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

Set the field separator to a colon in the data exported to c:\Employees.txt.

SET OPTION isql_field_separator=':';
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 start and end characters (in this case, single quotation marks) depend on the isql_quote setting.