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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Database Administration » Administering Your Database » SQL Anywhere graphical administration tools » Using Interactive SQL » Interactive SQL options

 

isql_quote option [Interactive SQL]

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

Allowed values

String

Default

A single apostrophe (')

Remarks

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.

See also
Example

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.