Chapter 5 Database Options
193
ISQL_PLAN option [ISQL]
Controls the amount of information displayed in the Messages pane after you
execute statements.
NONE, SHORT, LONG
SHORT
After you execute a SQL statement in Interactive SQL, the optimizer
provides information in the Messages pane about how it optimized the
execution. To determine the amount of information displayed, you can
choose one of three plans: NONE provides no information; SHORT provides
basic information; LONG provides detailed information.
You can specify whether the time of execution is included with any of these
plans by setting the "ISQL_COMMAND_TIMING option" on page 190.
You can also specify a plan on the Messages page of the Options dialog.
ISQL_QUOTE option [ISQL]
Controls the default string that begins and ends all strings in data exported to
ASCII files.
Any string
A single apostrophe ( ’ )
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.
♦ Set the field separator to a colon in the data exported to
c:\employee.txt
.
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
:
"Cobb","Matthew"
"Chin","Philip"
"Jordan","Julie"
The separator characters (in this case, commas) depend on the
ISQL_FIELD_SEPARATOR setting.
Function
Allowed values
Default
Description
Function
Allowed values
Default
Description
Example
To Next Page
Loading...