ISQL_FIELD_SEPARATOR option [DBISQL]

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.

• 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.