ASA Database Administration Guide
Database Options
Interactive SQL options
Syntax 1
SET [ TEMPORARY ] OPTION
[
userid. | PUBLIC. ]option-name = [
option-value ]
Syntax 2
SET PERMANENT
Syntax 3
SET
Parameters
userid:
identifier,
string or
host-variable
option-name:
identifier,
string or
host-variable
option-value:
host-variable (indicator allowed),
string,
identifier, or
number
Description
SET PERMANENT (syntax 2) stores all current Interactive SQL options in the SYSOPTION system table. These settings are automatically established every time Interactive SQL is started for the current user ID.
Syntax 3 is used to display all of the current option settings. If any options have temporary settings for Interactive SQL or the database server, these are displayed; otherwise, the permanent option settings are displayed.
|
OPTION
|
VALUES
|
DEFAULT
|
|---|
|
AUTO_COMMIT option [ISQL]
|
ON, OFF
|
OFF
|
|
AUTO_REFETCH option [ISQL]
|
ON, OFF
|
ON
|
|
BELL option [ISQL]
|
ON, OFF
|
ON
|
|
COMMAND_DELIMITER option [ISQL]
|
String
|
' ; '
|
|
COMMIT_ON_EXIT option [ISQL]
|
ON, OFF
|
ON
|
|
DESCRIBE_JAVA_FORMAT option [ISQL]
|
Varchar, binary
|
Varchar
|
|
ECHO option [ISQL]
|
ON, OFF
|
ON
|
|
INPUT_FORMAT option [ISQL]
|
ASCII, DBASE, DBASEII, DBASEIII, EXCEL, FIXED, FOXPRO, LOTUS
|
ASCII
|
|
ISQL_COMMAND_TIMING option [ISQL]
|
ON, OFF
|
ON
|
|
ISQL_ESCAPE_CHARACTER option [ISQL]
|
Character
|
' \ '
|
|
ISQL_FIELD_SEPARATOR option [ISQL]
|
String
|
' , '
|
|
ISQL_LOG option [ISQL]
|
File-name
|
(empty string)
|
|
ISQL_PLAN option [ISQL]
|
NONE, SHORT, LONG, GRAPHICAL, GraphicalWithStatistics
|
SHORT
|
|
ISQL_PRINT_RESULT_SET option [ISQL]
|
LAST, ALL, NONE
|
LAST
|
|
ISQL_QUOTE option [ISQL]
|
String
|
'
|
|
NULLS option [ISQL]
|
String
|
'(NULL)'
|
|
ON_ERROR option [ISQL]
|
STOP, CONTINUE, PROMPT, EXIT, NOTIFY_CONTINUE, NOTIFY_STOP, NOTIFY_EXIT
|
PROMPT
|
|
OUTPUT_FORMAT option [ISQL]
|
ASCII, DBASEII, DBASEIII, EXCEL, FIXED, FOXPRO, HTML, LOTUS, SQL, XML,
|
ASCII
|
|
OUTPUT_LENGTH option [ISQL]
|
Integer
|
0
|
|
OUTPUT_NULLS option [ISQL]
|
String
|
'NULL'
|
|
STATISTICS option [ISQL]
|
0,3,4,5,6
|
3
|
|
TRUNCATION_LENGTH option [ISQL]
|
Integer
|
256
|
|
|
|