This is an old revision of the document!
Overview | Commands | Options | Command-line | Command Files
There are many options that can be set in OdxSQL. They are described below.
The SET API option
The default setting is OA.
SET API <OA | ODBC | JDBC>
The SET AUTODISPLAY option
The default setting is LIST.
SET AUTODISPLAY <LIST | FORM>
The SET AUTOEXPLAIN option
The default setting is OFF.
SET AUTOEXPLAIN <ON | OFF | AFTER>
The SET AUTOFETCH option
The default setting is ON.
SET AUTOFETCH <ON | OFF>
The SET AUTORESET option
The default setting is OFF.
SET AUTORESET <ON | OFF>
The SET CHAR option
The default setting is AUTO.
SET CHAR <AUTO | n>
The SET CURSOR option
The default setting is 0.
SET CURSOR n
The SET CURSORDISPLAY option
The default setting is OFF.
SET CURSORDISPLAY <ON | OFF>
The SET DEFAULTS option
SET DEFAULTS
The SET EDITOR option
The default setting is DEFAULT.
SET EDITOR <NOTEPAD | WORDPAD | VI | EMACS | path
The SET ERRORDISPLAY option
The default setting is MESSAGE.
SET ERRORDISPLAY <NONE | MESSAGE | DETAIL | FULL>
The SET ERRORS option
The default setting is ABORT.
SET ERRORS <ABORT | CONTINUE | EXIT>
The SET EXPLAIN option
The default setting is NOCOUNTS SUMMARY DETAILS ADDIN NOTEXT NONODES.
SET EXPLAIN [<COUNTS | NOCOUNTS>] [<TEXT | NOTEXT>] [<NODES | NONODES>]
The SET HEADERS option
The default setting is ON.
SET HEADERS <ON | OFF>
The SET HEX option
The default setting is HEX.
SET HEX <ON | OFF | ONLY>
The SET HISTORY option
The default setting is 100.
SET HISTORY n
The SET INSTANCE option
The default setting is 0.
SET INSTANCE n
The SET INTERRUPTS option
The default setting is ON.
SET INTERRUPTS <ON | OFF | API>
The SET MULTICONNECT option
The default setting is OFF.
SET MULTICONNECT] <ON | OFF
The SET MULTILINE option
The default setting is OFF.
SET MULTILINE] <ON | OFF | n
The SET NULL_INDICATORS option
The default setting is OFF.
SET NULL_INDICATORS <ON | OFF | string>
The SET OMNIDEX_DEBUG option
The default setting is OFF.
SET OMNIDEX_DEBUG <ON | OFF | profile> [FILE=filename] [FOR SERVER]
The SET OPTIMIZATION option
The default setting is DEFAULT.
SET OPTIMIZATION options
The SET PAGELENGTH option
The default setting is 24.
SET PAGELENGTH n
The SET PAGEWIDTH option
The default setting is 80.
SET PAGEWIDTH n
The SET POWERSEARCH option
The default setting is OFF.
SET POWERSEARCH <ON | OFF | list>
The SET PROMPT option
The default setting is “> ”.
SET PROMPT ["string"] [WITH [FILE] [LINE] [COMMAND]]
The SET QUALIFY_COUNTS option
The default setting is PARENT NOPREINTERSECT.
SET QUALIFY_COUNTS [<PARENT | NOPARENT>] [<PREINTERSECT | NOPREINTERSECT>]
The SET QUALIFY_MODE option
The default setting is PARSER.
SET QUALIFY_MODE <PARSER | ODXFIND | OX_FIND>
The SET REQUIRED_OPTIMIZATION option
The default setting is NONE.
SET REQUIRED_OPTIMIZATION options
The SET SILENT_MODE option
The default setting is OFF.
SET SILENT_MODE <ON | OFF>
The SET SQL_SYNTAX option
The default setting is OMNIDEX.
SET SQL_SYNTAX <OMNIDEX | ORACLE | SQLSERVER>
The SET STATISTICS option
The default setting is OFF.
SET STATISTICS <ON | OFF | filename>
The SET STATUSDISPLAY option
The default setting is OFF.
SET STATUSDISPLAY <ON | OFF>
The SET TIMEOUT option
The default setting is OFF.
SET TIMEOUT <seconds | OFF>
The SET TIMER option
The default setting is OFF.
SET TIMER <ON | CUMULATIVE | OFF>
The SET TIMEZONE option
The default setting is the timezone for the server.
SET TIMEZONE timezone
See also: