This is an old revision of the document!


DRAFT

OdxSQL Quick Reference

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 OFFWill process SQL Statements without requiring a semi-colon terminator.
SET TIMER ONUseful to show how long a statement takes to process.
Help/Show
HELPShows 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 ALLProvides 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 filespecTypically used to edit a script file and then use the USE file to run the script.
EDIT nEdits the command in the Command History Stack
Other Commands
HISTORYShows 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.
EXPLAINShows the Explain Plan for the previous SELECT Statement.
SET AUTOEXPLAIN ONAutomatically show the Explain after a SELECT Statement.
 
Back to top
programs/odxsql/home.1278206598.txt.gz ยท Last modified: 2016/06/28 22:38 (external edit)