ODXSQL Commands

SET

SET [(option | ?)]

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.

Example

> SET AUTOFETCH OFF

> SET ?
SET
[AUTODISPLAY <LIST | FORM>]
[AUTOEXPLAIN <ON | OFF>]
[AUTOFETCH <ON | OFF>]
[AUTOPSEUDOCOLUMNS <ON | OFF>]
[AUTORECONNECT <ON | OFF>]
[AUTOSUBPROCESS <n | NONE>
[CHAR <AUTO | n>]
[CURSOR n]
[CURSORDISPLAY <ON | OFF>]
[DEFAULTS]
[EDITOR <NOTEPAD | WORDPAD | VI | EMACS | path>
[ENDIAN <LITTLE | BIG | NATIVE | OPPOSITE>
[ERRORDISPLAY <MESSAGE | DETAIL | FULL>]
[ERRORS <ABORT | CONTINUE | EXIT>]
[EXPLAIN <[NO]COUNTS|[NO]SUMMARY|[NO]DETAILS|[NO]ADDIN>
[FILE_BASELINE]
[HEADERS <ON | OFF>]
[HEX <ON | OFF | ONLY>]
[HISTORY n]
[INSTANCE n]
[INTERRUPTS <ON | OFF | API>]
[MEMORY_BASELINE]
[NULL_INDICATORS <ON | OFF | string>]
Press <RETURN> to continue or '/' to stop paging ...
[DEBUG <ON | OFF | PROFILE=profile> [FILE=filename]]
[OPTIMIZATION options]
[ODXSQL_DEBUG <PARSE | FILE | DEBUG | ALL> <ON | OFF>]
[PAGELENGTH n]
[PAGEWIDTH n]
[PROMPT ["string"] [WITH [FILE] [LINE] [COMMAND]]]
[PREPROCESSOR <ON | OFF>]
[PSEUDOCOLUMNS <ON | OFF>]
[QUALIFY_COUNTS <PARENT | NOPARENT>]
[REDEFROWIDS <ON | OFF>]
[REQUIRED_OPTIMIZATION options]
[SQL_LOGGING <ON | OFF> [WITH options]]
[SILENT_MODE <ON | OFF>]
[STATISTICS <ON | OFF | filename>]
[STATUSDISPLAY <ON | OFF>]
[TIMER <ON | CUMULATIVE | OFF>]
[TIMEOUT <seconds | OFF>]

> SET

Current settings:
API OA
AUTODISPLAY LIST
AUTOEXPLAIN OFF
AUTOFETCH OFF
AUTOPSEUDOCOLUMNS OFF
AUTOSUBPROCESS NONE
CHAR AUTO
CURSOR 1
CURSORDISPLAY OFF
DEBUG OFF
EDITOR DEFAULT
ENDIAN LITTLE
ERRORDISPLAY MESSAGE
ERRORS ABORT
EXPLAIN NOCOUNTS SUMMARY DETAILS ADDIN
FILE_BASELINE OFF
HEADERS ON
HEX OFF
HISTORY 100
INSTANCE 1
INTERRUPTS ON (currently armed)
MEMORY_BASELINE OFF
Press <RETURN> to continue or '/' to stop paging ...
NULL_INDICATORS OFF
OPTIMIZATION DEFAULT
PAGELENGTH 24
PAGEWIDTH 80
PROMPT "> "
PREPROCESSOR ON
PSEUDOCOLUMNS ON
QUALIFY_COUNTS PARENT
REDEFROWIDS ON
REQUIRED_OPTIMIZATION NONE
SILENT_MODE OFF
SQL_LOGGING OFF
STATISTICS OFF
STATUSDISPLAY OFF
TIMER OFF
TIMEOUT INACTIVE

Options

AUTODISPLAY <LIST | FORM>
AUTOEXPLAIN <ON | OFF>
AUTOFETCH <ON | OFF>
AUTOPSEUDOCOLUMNS <ON | OFF>
AUTORECONNECT <ON | OFF>
AUTOSUBPROCESS <n | NONE>
CHAR <AUTO | n>
CURSOR n
CURSORDISPLAY <ON | OFF>
DEFAULTS
EDITOR <NOTEPAD | WORDPAD | VI | EMACS | path>
ENDIAN <LITTLE | BIG | NATIVE | OPPOSITE>
ERRORDISPLAY <MESSAGE | DETAIL | FULL>
ERRORS <ABORT | CONTINUE | EXIT>
EXPLAIN <[NO]COUNTS|[NO]SUMMARY|[NO]DETAILS|[NO]ADDIN>
FILE_BASELINE
HEADERS <ON | OFF>
HEX <ON | OFF | ONLY>
HISTORY n
INSTANCE n
INTERRUPTS <ON | OFF | API>
MEMORY_BASELINE
NULL_INDICATORS <ON | OFF | string>
DEBUG <ON | OFF | PROFILE=profile> [FILE=filename]
OPTIMIZATION options
ODXSQL_DEBUG <PARSE | FILE | DEBUG | ALL> <ON | OFF>
PAGELENGTH n
PAGEWIDTH n
PROMPT ["string"] [WITH [FILE] [LINE] [COMMAND]]
PREPROCESSOR <ON | OFF>
PSEUDOCOLUMNS <ON | OFF>
QUALIFY_COUNTS <PARENT | NOPARENT>
REDEFROWIDS <ON | OFF>
REQUIRED_OPTIMIZATION options
SQL_LOGGING <ON | OFF> [WITH options]
SILENT_MODE <ON | OFF>
STATISTICS <ON | OFF | filename>
STATUSDISPLAY <ON | OFF>
TIMER <ON | CUMULATIVE | OFF>
TIMEOUT <seconds | OFF>

top