DRAFT

OdxSQL Settings

OdxSQL's operation is controlled by several settings. These settings can be dynamically changed by using the OdxSQL SET Command. The following is a list of all of the available OdxSQL settings.

OdxSQL Settings
API AUTODISPLAY AUTOEXPLAIN AUTOFETCH AUTOPSEUDOCOLUMNS AUTORECONNECT
AUTOSUBPROCESSCHARCURSORCURSORDISPLAYDEFAULTSEDITOR
ENDIAN ERRORDISPLAYERRORSEXPLAINFILE_BASELINEHEADERS
HEXHISTORYINSTANCEINTERRUPTSMEMORY_BASELINEMULTICONNECT
MULTILINENULL_INDICATORSOMNIDEX_DEBUGOPTIMIZATIONODXSQL_DEBUGPAGELENGTH
PAGEWIDTHPREPROCESSORPROGRESSPROMPTPSEUDOCOLUMNSQUALIFY_COUNTS
REDEFROWIDSREQUIRED_OPTIMIZATIONSILENT_MODESQL_LOGFILESQL_LOGGINGSQL_SYNTAX
STATISTICSSTATISTICS_COMMENTSTATUSDISPLAYTERMINATIONTIMEOUTTIMER

To see OdxSQL's current settings, issue the SET Command without any arguments.

> SET

To see OdxSQL's a list of all the settings and the available setting values issue the SET ? command.

> SET ? 

OdxSQL All Settings in Alphabetical Order

Setting Default Other Options Description
API OA ODBC | JDBC | CLOA Sets which API to use before the first CONNECT Statement.
AUTODISPLAY LIST FORM Sets Columns across (LIST) or Columns stacked (FROM).
AUTOEXPLAIN OFF ON | AFTER Shows the Explain Plan for the SELECT statement instead of processing the SELECT.
AUTOFETCH ON OFF Automatically fetch records after a SELECT or QUALIFY.
AUTOPSEUDOCOLUMNS OFF ON
AUTORECONNECT OFF ON
AUTOSUBPROCESS NONE n
CHAR AUTO n
CURSOR last opened n Sets the default Cursor to use for processing.
CURSORDISPLAY OFF ON The cursor number being used can be set to automatically display.
DEFAULTS <none> <none> Resets all settings to their initial defaults.
EDITOR NOTEPAD or vi WORDPAD | EMACS | path Sets which editor to use with the EDIT Command
ENDIAN LITTLE BIG | NATIVE | OPPOSITE
ERRORDISPLAY MESSAGE NONE | DETAIL | FULL
ERRORS ABORT CONTINUE | EXIT Set processing errors of statements from a USE file.
EXPLAIN SUMMARY DETAILS ADDIN [NO]COUNTS | TEXT Sets the EXPLAIN Command options.
FILE_BASELINE OFF
HEADERS ON OFF Turn the Column Headers ON or OFF.s
HEX OFF ON | ONLY Set the display of output values in HEX
HISTORY 100 n Sets the size of the Command History stack.
INSTANCE last connection n Sets the default Instance to use for processing.
INTERRUPTS ON OFF | API
MEMORY_BASELINE OFF
MULTICONNECT OFF ON Allows OdxSQL to connect to multiple Environments.
MULTILINE OFF ON | n
NULL_INDICATORS OFF ON | string
ODXSQL_DEBUG <PARSE | FILE | DEBUG | ALL> <ON | OFF>
OMNIDEX_DEBUG OFF ON | profile [FILE=filename] When ON, writes Omnidex debugging to odxdebug.log or to a named file with FILE clause.
OPTIMIZATION DEFAULT options
PAGELENGTH 24 n Set the page length before the paging prompt is issued.
PAGEWIDTH 80 n Sets the page width of the display.
PREPROCESSOR ON OFF Can disable the use of the Omnidex SQL Preprocessor. Use only for testing.
PROGRESS OFF ON
PROMPT ”> ” “string” [WITH [FILE] [LINE] [COMMAND]] Sets the OdxSQL command prompt.
PSEUDOCOLUMNS ON OFF
QUALIFY_COUNTS PARENT NOPARENT
QUALIFY_MODE PARSER ODXFIND | OX_FIND Changes the Qualify Mode to internal routines.
REDEFROWIDS ON OFF
REQUIRED_OPTIMIZATION NONE options
SILENT_MODE OFF ON
SQL_LOGFILE DEFAULT filename
SQL_LOGGING OFF ON [WITH options]
STATISTICS OFF ON | filename
STATISTICS_COMMENT none “string”
STATUSDISPLAY OFF ON
TIMEOUT OFF seconds
TIMER OFF ON | CUMULATIVE Shows the CPU and Elapsed time of statements.

Examples

set autoexplain on
set explain counts, text
set pagelength 0
set timer on
SET STATISTICS on
 
Back to top
programs/odxsql/settings/home.txt · Last modified: 2016/06/28 22:38 (external edit)
 
 
chimeric.de = chi`s home Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0