ASA Database Administration Guide
  Database Options
    Alphabetical list of options

ISQL_FIELD_SEPARATOR option [ISQL]

Function 

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

Allowed values 

String

Default 

A comma ( , )

Description 

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.

Example 

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

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