This is an old revision of the document!
| Command Line Options | Description |
|---|---|
| odxsql | Run OdxSQL. Use the CONNECT command to connect to an Omnidex Environment |
| odxsql env_filespec | Run OdxSQL and connect to the env_filespec. |
| odxsql dsn_filespec -odbc | Run OdxSQL and connect to the ODBC File DSN using the Omnidex ODBC driver. |
| odxsql env_filespec -odxnet -jdbc | Run OdxSQL and start an OdxNet background process and connect to the env_filespec using the Omnidex JDBC driver. |
| odxsql -? | Displays OdxSQL command line options |
| odxsql -use scriptfile | Run OdxSQL and read and process the scriptfile of OdxSQL Statements and Commands. |
| Set Command | |
| SET | Shows the current settings. |
| SET ? | Shows the list of available SET options. |
| SET TERMINATION OFF | Will process SQL Statements without requiring a semi-colon terminator. |
| SET TIMER ON | Useful to show how long a statement takes to process. |
| Help/Show | |
| HELP | Shows a list of OdxSQL commands and SQL Statements. |
| HELP <command> | Provides specific help on the specified command or SQL Statement. |
| SHOW <table> | Provides information on the specified table. |
| SHOW ALL | Provides information on all tables. |
| Editing | |
| EDIT | Launch editor and send current SQL Statement to either Windows Notedpad or UNIX/Linux vi or emacs. |
| SET EDITOR <filespec> | Change the default editor. Can also be NOTEPAD, WORDPAD, VI or EMACS. |
| EDIT filespec | Typically used to edit a script file and then use the USE file to run the script. |
| EDIT n | Edits the command in the Command History Stack |
| Other Commands | |
| HISTORY | Shows a numbered list of previously entered commands. |
| <command_number> | Execute the numbered command from the Command History Stack. |
| Period(.) | Execute the last command. |
| USE <filespec> | Processes the OdxSQL commands in a script file. |
| EXPLAIN | Shows the Explain Plan for the previous SELECT Statement. |
| SET AUTOEXPLAIN ON | Automatically show the Explain after a SELECT Statement. |
| OdxSQL Settings | |||||
|---|---|---|---|---|---|
| API | AUTODISPLAY | AUTOEXPLAIN | AUTOFETCH | AUTOPSEUDOCOLUMNS | AUTORECONNECT |
| AUTOSUBPROCESS | CHAR | CURSOR | CURSORDISPLAY | DEFAULTS | EDITOR |
| ENDIAN | ERRORDISPLAY | ERRORS | EXPLAIN SET | FILE_BASELINE | HEADERS |
| HEX | HISTORY | INTERRUPTS | MEMORY_BASELINE | MULTICONNECT | MULTILINE |
[HISTORY n] [INSTANCE n] [INTERRUPTS <ON | OFF | API>]
Press <RETURN> to continue or '/' to stop paging …
[MEMORY_BASELINE] [MULTICONNECT] <ON | OFF> [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]] [SQL_SYNTAX <OMNIDEX | ORACLE | SQLSERVER>] [STATISTICS <ON | OFF | filename>] [STATISTICS_COMMENT "string"]
Press <RETURN> to continue or '/' to stop paging …
[STATUSDISPLAY <ON | OFF>] [TERMINATION <ON | OFF>] [TIMEOUT <seconds | OFF>] [TIMER <ON | CUMULATIVE | OFF>]