Reference Manual
CHAPTER 5. Database Options
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 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 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 |
|---|---|---|
ON, OFF |
OFF |
|
ON, OFF |
ON |
|
ON, OFF |
ON |
|
ON, OFF, DETECT |
DETECT |
|
string |
';' |
|
ON, OFF |
ON |
|
Varchar, binary |
Varchar |
|
ON, OFF |
ON |
|
ON, OFF |
ON |
|
ASCII DBASE DBASEII DBASEIII DIF FIXED FOXPRO LOTUS WATFILE |
ASCII |
|
file-name |
(empty string) |
|
ON, OFF |
'(NULL)' |
|
STOP CONTINUE PROMPT EXIT NOTIFY_CONTINUE NOTIFY_STOP NOTIFY_EXIT |
PROMPT |
|
TEXT ASCII FIXED DIF DBASEII DBASEIII FOXPRO LOTUS SQL WATFILE |
ASCII |
|
integer |
0 |
|
0,3,4,5,6 |
3 |
|
integer |
30 |