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 | Description |
SET | Shows the current settings. |
SET ? | Shows the list of available SET options. |
SET TERMINATION OFF | Will Automatically terminate SQL Statements. |
Help/Show | Description |
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. |