ASA Database Administration Guide
  Database Options
    Alphabetical list of options

ISQL_QUOTE option [ISQL]

Function 

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

Allowed values 

String

Default 

A single apostrophe ( ' )

Description 

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.

Example 

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

  SET TEMPORARY OPTION ISQL_QUOTE='"';
  SELECT emp_lname, emp_fname FROM employee WHERE emp_id < 150;
  OUTPUT TO c:\employee.txt FORMAT ASCII

  This code places the following data in employee.txt:

  "Whitney", "Fran"

  "Cobb","Matthew"

  "Chin","Philip"

  "Jordan","Julie"

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