Alphabetical list of options
192
ISQL_FIELD_SEPARATOR option [ISQL]
Controls the default string used for separating values in data exported to
ASCII files.
Any 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
:
’Cobb’:’Matthew’
’Chin’:’Philip’
’Jordan’:’Julie’
The start and end characters (in this case, single quotation marks)
depend on the ISQL_QUOTE setting.
ISQL_LOG option [ISQL]
Controls logging behavior.
String containing a file name.
Empty string.
If ISQL_LOG is set to a non-empty string, all Interactive SQL statements are
added to the end of the named file. Otherwise, if ISQL_LOG is set to the
empty string, Interactive SQL statements are not logged.
Individual session only
This option logs an individual Interactive SQL session only. See "Backup
and Data Recovery" on page 645 of the book ASA User’s Guide for a
description of the transaction log that logs all changes to the database by
all users.
Function
Allowed values
Default
Description
Example
Function
Allowed values
Default
Description
To Next Page
Loading...