SET
The SET command is used to set options that define the behavior of ODXSQL.
View the current settings by entering SET without any options at the
ODXSQL prompt.
Current settings can be saved by using the SAVE SETTINGS commands. Saved
settings can be restored using the RESTORE SETTINGS command.
Options must be set one at a time.
Syntax
SET [option | ?]
SET
Required.
option | ?
Optional. Options is option to set. ? displays help information about
the set command. If both are omitted, the current settings will be displayed.
Options
AUTODISPLAY
AUTOEXPLAIN
AUTOFETCH
AUTOPSEUDOCOLUMNS
AUTORECONNECT
AUTOSUBPROCESS
CHAR
CURSOR
CURSORDISPLAY
DEFAULTS
EDITOR
ENDIAN
ERRORDISPLAY
ERRORS
EXPLAIN
FILE_BASELINE
HEADERS
HEX
HISTORY
INSTANCE
INTERRUPTS
MEMORY_BASELINE
NULL_INDICATORS
OMNIDEX_DEBUG
OPTIMIZATION
PAGELENGTH
PAGEWIDTH
PROMPT
PREPROCESSOR
PSEUDOCOLUMNS
QUALIFY_COUNTS
QUALIFY_MODE
REDEFROWIDS
REQUIRED_OPTIMIZATION
SQL_LOGGING
SILENT_MODE
STATISTICS
STATUSDISPLAY
TIMER
TIMEOUT
Example
> set cursordisplay on
> set prompt ##:
##:set
Current settings:
API OA
AUTODISPLAY LIST
AUTOEXPLAIN OFF
AUTOFETCH ON
AUTOPSEUDOCOLUMNS OFF
AUTOSUBPROCESS NONE
CHAR AUTO
CURSOR 1
CURSORDISPLAY ON
EDITOR DEFAULT
ENDIAN LITTLE
ERRORDISPLAY MESSAGE
ERRORS ABORT
EXPLAIN NOCOUNTS SUMMARY DETAILS ADDIN TEXT
FILE_BASELINE OFF
HEADERS ON
HEX OFF
HISTORY 100
INSTANCE 1
INTERRUPTS ON (currently armed)
MEMORY_BASELINE OFF
NULL_INDICATORS OFF
Press <RETURN> to continue or '/' to stop paging ...
OMNIDEX_DEBUG OFF
OPTIMIZATION DEFAULT
PAGELENGTH 24
PAGEWIDTH 80
PROMPT "##:"
PREPROCESSOR ON
PSEUDOCOLUMNS ON
QUALIFY_COUNTS PARENT
QUALIFY_MODE ODXFIND
REDEFROWIDS ON
REQUIRED_OPTIMIZATION NONE
SILENT_MODE OFF
SQL_LOGGING OFF
STATISTICS OFF
STATUSDISPLAY OFF
TIMEOUT OFF
TIMER OFF
##:
Top
|
