* [[topbar |Table of Contents]] * [[intro:overview:what|Introduction]] * [[install:home|Installation]] * [[install:editions|Product Editions]] * [[install:requirements|System Requirements]] * [[install:platforms|Supported Platforms]] * [[install:guides:home|Installation Guides]] * [[install:licensing:home|Licensing]] * [[install:releases:home|Release Notes]] * [[admin:home|Administration]] * [[admin:admin:home|Administration Basics]] * [[admin:admin:architecture:home|Omnidex Architecture]] * [[admin:admin:applications:home|Building Applications]] * [[admin:basics:home|Omnidex Fundamentals]] * [[admin:basics:environments:home|Omnidex Environments]] * [[admin:basics:sqlengine:home|Omnidex SQL Engine]] * [[admin:basics:updates:home|Omnidex Updates]] * [[admin:basics:network:home|Network Services]] * [[admin:indexing:home|Omnidex Indexing]] * [[admin:indexing:concepts:home|Indexing Concepts]] * [[admin:indexing:indexes:home|Indexing Options]] * [[admin:indexing:creation:home|Index Creation]] * [[admin:indexing:strategies:home|Indexing Strategies]] * [[admin:indexing:activecounts:home|ActiveCounts]] * [[admin:indexing:powersearch:home|PowerSearch]] * [[admin:indexing:autocomplete:home|AutoComplete]] * [[admin:indexing:text:home|Omnidex Text]] * [[admin:features:home|Omnidex Features]] * [[admin:features:snapshots:home|Omnidex Snapshots]] * [[admin:features:grids:home|Omnidex Grids]] * [[admin:features:rollups:home|Rollup Tables]] * [[admin:features:geo:home|Geographic Searches]] * [[admin:features:expressioncols:home|Expression Columns]] * [[admin:features:segments:home|Omnidex Segments]] * [[admin:features:attach:home|Attaching Data]] * [[admin:features:export:home|Exporting Data]] * [[admin:optimization:home|Optimizing Queries]] * [[admin:optimization:plans:home|Query Plans]] * [[admin:optimization:caches:home|Dynamic Caches]] * [[admin:optimization:config:home|Configuring Omnidex]] * [[integration:home|Integration]] * [[integration:rdbms:home|Relational Databases]] * [[integration:rdbms:oracle:home|Oracle]] * [[integration:rdbms:sqlserver:home|SQL Server]] * [[integration:rdbms:mysql:home|MySQL]] * [[integration:rdbms:odbc:home|Generic ODBC]] * [[integration:rawdata:home|Raw Data Files]] * [[integration:rawdata:fixed:home|Fixed-length Files]] * [[integration:rawdata:delimited:home|Delimited Files]] * [[integration:rawdata:ost:home|Standalone Tables]] * [[dev:home|Development]] * [[dev:sql:home|Omnidex SQL]] * [[dev:sql:overview|Overview]] * [[dev:sql:statements:home|Statements]] * [[dev:sql:functions:home|Functions]] * [[dev:sql:examples:home|Examples]] * [[dev:connections:home|Connection Strings]] * [[dev:odbc:home|ODBC Interface]] * [[dev:jdbc:home|JDBC Interface]] * [[dev:debugging:home|Logging/Debugging]] * [[programs:home|Programs]] * [[programs:odxsql:home|OdxSQL]] * [[programs:odxnet:home|OdxNet]] * [[appendix:home|Appendix]] * [[dev:sql:home|Omnidex SQL]] * [[dev:sql:statements:home|Statements]] * [[dev:sql:functions:home|Functions]] * [[dev:sql:examples:home|Examples]] * [[http://www.omnidex.com/download/|Downloads]] * [[support:home|Support]]

{{page>:top_add&nofooter&noeditbtn}} ~~NOTOC~~ ====== Programs: OdxSQL ====== [[programs:odxsql:home|Overview]] | [[programs:odxsql:commands|Commands]] | **[[programs:odxsql:options|Options]]** | [[programs:odxsql:cmdline|Command-line]] | [[programs:odxsql:files|Command Files]] ---- ===== Options ===== There are many options that can be set in OdxSQL. They are described below. ==== SET API ==== The SET command by itself shows the values for all of the settings in OdxSQL. <code> SET </code> ==== SET API ==== The SET API option determines whether statements should be run through the default API, called OmniAccess, or through the client interfaces of ODBC and JDBC. The default setting is OA. <code> SET API <OA | ODBC | JDBC> </code> ==== SET AUTODISPLAY ==== The SET AUTODISPLAY option determines whether the results from a SELECT statement should be displayed using a LIST view or a FORM view. In a LIST view, multiple columns appear per row with column headings at the top. In a FORM view, each column for each row is displayed on a separate line. The default setting is LIST. <code> SET AUTODISPLAY <LIST | FORM> </code> ==== SET AUTOEXPLAIN ==== The SET AUTOEXPLAIN option determines whether the query plan for a SELECT statement should be displayed. The value of ON shows the query plan instead of the result set, and the value of AFTER shows the query plan after the result set. The default setting is OFF. <code> SET AUTOEXPLAIN <ON | OFF | AFTER> </code> ==== SET AUTOFETCH ==== The SET AUTOFETCH option determines whether the results from a SELECT statement should be automatically fetched and displayed. The default setting is ON. <code> SET AUTOFETCH <ON | OFF> </code> ==== SET AUTORESET ==== The SET AUTORESET option determines whether QUALIFY statements that return a zero qualifying count are automatically backed out. The default setting is OFF. <code> SET AUTORESET <ON | OFF> </code> ==== SET CHAR ==== The SET CHAR option determines the number of characters display for binary data. The default setting is AUTO. <code> SET CHAR <AUTO | n> </code> ==== SET CURSOR ==== The SET CURSOR option determines which cursor to use for subequent statements. This is only relevant if the OPEN CURSOR command has been issued. The default setting is 0. <code> SET CURSOR n </code> ==== SET CURSORDISPLAY ==== The SET CURSORDISPLAY option displays the cursor used for each statement. The default setting is OFF. <code> SET CURSORDISPLAY <ON | OFF> </code> ==== SET DEFAULTS ==== The SET DEFAULTS option returns all settings to their default values. <code> SET DEFAULTS </code> ==== SET ERRORDISPLAY ==== The SET ERRORDISPLAY option determines how much detail to show when an error occurs. The default setting is MESSAGE. <code> SET ERRORDISPLAY <NONE | MESSAGE | DETAIL | FULL> </code> ==== SET ERRORS ==== The SET ERRORS option determines what action to take if a statement produces an error condition. This setting only applies when statements are run in a command file with the USE <file> command. The value of ABORT causes the processing of the command file to stop. The value of CONTINUE causes the processing to continue. The value of EXIT causes the processing of the command file to stop and OdxSQL to exit with an error status. The default setting is ABORT. <code> SET ERRORS <ABORT | CONTINUE | EXIT> </code> ==== SET EXPLAIN ==== The SET EXPLAIN option determines what information to display in query plans. The value of COUNTS displays row counts and timings. The value of TEXT displays PowerSearch translations. <code> SET EXPLAIN [<COUNTS | NOCOUNTS>] [<TEXT | NOTEXT>] </code> ==== SET HEADERS ==== The SET HEADERS option determines whether column headers will be displays after results have been fetched from a SELECT statement. The default setting is ON. <code> SET HEADERS <ON | OFF> </code> ==== SET HEX ==== The SET HEX option determines whether the results of a SELECT statement should be display in hex. The default setting is HEX. <code> SET HEX <ON | OFF | ONLY> </code> ==== SET HISTORY ==== The SET HISTORY option determines how many statements to record in the history stack for this session of OdxSQL. The default setting is 100. <code> SET HISTORY n </code> ==== SET INSTANCE ==== The SET INSTANCE option determines which instance to use for subsequent statements. This is only relevant if the SET MULTICONNECT ON option has been issued. The default setting is 0. <code> SET INSTANCE n </code> ==== SET MULTICONNECT ==== The SET MULTICONNECT option determines whether a CONNECT statement will automatically disconnect the current connection or establish an additional, concurrent connection. The default setting is OFF. <code> SET MULTICONNECT] <ON | OFF </code> ==== SET MULTILINE ==== The SET MULTILINE option determines whether long character or string columns will be display on multiple lines. The default setting is OFF. <code> SET MULTILINE] <ON | OFF | n </code> ==== SET NULL_INDICATORS ==== The SET NULL_INDICATORS option determines whether null indicators will be shown in the result set for a SELECT statement. The default setting is OFF. <code> SET NULL_INDICATORS <ON | OFF | string> </code> ==== SET OMNIDEX_DEBUG ==== The SET OMNIDEX_DEBUG option allows debug settings to be issued from within OdxSQL. The default setting is OFF. <code> SET OMNIDEX_DEBUG <ON | OFF | profile> [FILE=filename] [FOR SERVER] </code> ==== SET PAGELENGTH ==== The SET PAGELENGTH option determines how many lines to display per page. The value of 0 disables all paging. The default setting is 24. <code> SET PAGELENGTH n </code> ==== SET PAGEWIDTH ==== The SET PAGEWIDTH option determines how many columns to display per page. The default setting is 80. <code> SET PAGEWIDTH n </code> ==== SET POWERSEARCH ==== The SET POWERSEARCH option determines whether queries should automatically use PowerSearch. The default setting is OFF. <code> SET POWERSEARCH <ON | OFF | list> </code> ==== SET PROMPT ==== The SET PROMPT option determines the prompt to use within OdxSQL. The default setting is "> ". <code> SET PROMPT ["string"] [WITH [FILE] [LINE] [COMMAND]] </code> ==== SET QUALIFY_COUNTS ==== The SET QUALIFY_COUNTS option determines which types of counts to display following QUALIFY and JOIN commands. The default setting is PARENT NOPREINTERSECT. <code> SET QUALIFY_COUNTS [<PARENT | NOPARENT>] [<PREINTERSECT | NOPREINTERSECT>] </code> ==== SET QUALIFY_MODE ==== The SET QUALIFY_MODE option determines whether to use the current parser for QUALIFY statements, or the legacy parsers from earlier versions of Omnidex. The default setting is PARSER. <code> SET QUALIFY_MODE <PARSER | ODXFIND | OX_FIND> </code> ==== SET SILENT_MODE ==== The SET SILENT_MODE option determines whether results should be displayed following SELECT statements. The default setting is OFF. <code> SET SILENT_MODE <ON | OFF> </code> ==== SET STATISTICS ==== The SET STATISTICS option determines whether to maintain a log of commands issued in OdxSQL. The log file is a delimited file named odxsql.log. The default setting is OFF. <code> SET STATISTICS <ON | OFF | filename> </code> ==== SET STATUSDISPLAY ==== The SET STATUSDISPLAY option determines whether to display the results of the internal status structure for every command. The status structure contains information about the statement, such as error codes and counts. The default setting is OFF. <code> SET STATUSDISPLAY <ON | OFF> </code> ==== SET TIMEOUT ==== The SET TIMEOUT option determines whether to automatically apply timeouts to SELECT statements. The default setting is OFF. <code> SET TIMEOUT <seconds | OFF> </code> ==== SET TIMER ==== The SET TIMER option determines whether to display timing statistics for each command. The value of CUMULATIVE displays a second clock with cumulative times since the last RESET TIMER command. The default setting is OFF. <code> SET TIMER <ON | CUMULATIVE | OFF> </code> ==== SET TIMEZONE ==== The SET TIMEZONE option determines the timezone to use for Omnidex statements. The default setting is the timezone for the server. <code> SET TIMEZONE timezone </code> ===== ===== **[[programs:odxsql:commands|Prev]]** | **[[programs:odxsql:cmdline|Next]]** ====== Additional Resources ====== See also: {{page>:programs:see_also&nofooter&noeditbtn}} {{page>:bottom_add&nofooter&noeditbtn}}

 
Back to top
programs/odxsql/options.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