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 Automatically terminate SQL Statements. |
| 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. |
| 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. |
| 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. |