OdxSQL Settings

set ?

SET

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

===== OdxSQL Default Settings =====

<code>
> set

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