Controls the default string that begins and ends all strings in data exported to text files.
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.
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.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |