These options change how DBISQL interacts with the database.
SET [ TEMPORARY ] OPTION ... [ userid. | PUBLIC. ]option-name = [ option-value ]
SET PERMANENT
SET
userid: identifier, string or host-variable
option-name: identifier, string or host-variable
option-value: host-variable (indicator allowed), string, identifier, or number
SET PERMANENT (Syntax 2) stores all current DBISQL options in the SYSOPTIONS system table. These settings are automatically established every time DBISQL is started for the current user ID.
Syntax 3 is used to display all of the current option settings. If there are temporary options set for DBISQL or the database server, these will be displayed; otherwise, the permanent option settings are displayed.
The following table lists the DBISQL options, their allowed values, and their default settings.
See the sections “General database options” and “Transact-SQL compatibility options” for lists of the other classes of options.
OPTION |
VALUES |
DEFAULT |
|---|---|---|
AUTO_COMMIT |
ON, OFF |
OFF |
AUTO_REFETCH |
ON, OFF |
ON |
BELL |
ON, OFF |
ON |
COMMAND_DELIMITER |
string |
';' |
COMMIT_ON_EXIT |
ON, OFF |
ON |
DEFAULT_ISQL_ENCODING |
identifier or string |
empty string (use system code page) |
ECHO |
ON, OFF |
ON |
HEADINGS |
ON, OFF |
ON |
INPUT_FORMAT* |
||
ISQL_COMMAND_TIMING |
ON, OFF |
ON |
ISQL_ESCAPE_CHARACTER |
single character |
\ (backslash) |
ISQL_FIELD_SEPARATOR |
string |
, (comma) |
ISQL_LOG |
file name |
'' |
ISQL_QUOTE |
string |
' (single apostrophe) |
NULLS |
ON, OFF |
NULL |
ON_ERROR |
STOP, CONTINUE, PROMPT, EXIT, NOTIFY_CONTINUE, NOTIFY_STOP, NOTIFY_EXIT |
PROMPT |
OUTPUT_FORMAT |
ASCII, DBASEII, DBASEIII, EXCEL, FIXED, FOXPRO, HTML, LOTUS, SQL, XML, |
ASCII |
OUTPUT_LENGTH |
Integer |
0 |
OUTPUT_NULLS |
String |
'NULL' |
STATISTICS |
0, 3, 4, 5, 6 |
3 |
TRUNCATION_LENGTH |
integer |
256 |
An asterisk (*) next to the option name in
the above table indicates an option that is currently not supported
by Sybase IQ.
