Interactive SQL options change how Interactive SQL interacts with the database.
userid: identifier, string or host-variable
option-name: identifier, string or host-variable
option-value: host-variable (indicator allowed), string, identifier, or number
Syntax 1 with the TEMPORARY keyword cannot be used between the BEGIN and END keywords of a compound statement.
Syntax 2 SET PERMANENT stores all current Interactive SQL options in the SYSOPTIONS 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 there are temporary options set for Interactive SQL or the database server, these are displayed; otherwise, the permanent option settings are displayed.
Option |
Allowed values |
Default setting |
---|---|---|
DEFAULT_ISQL_ENCODING |
Identifier or string |
empty string (use system code page) |
NULLS* |
String |
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* |
Non-negative integer |
0 (no truncation) |
OUTPUT_NULLS* |
String |
'NULL' |
STATISTICS* |
0, 3, 4, 5, 6 |
3 |
TRUNCATION_LENGTH* |
Integer |
256 |