This is an old revision of the document!
OdxSQL can accept the Omnidex Environment as well as several other options.
If the Omnidex Environment is specified, OdxSQL will automatically attempt to connect to the specified Environment.
odxsql [Omnidex_Environment_Filespec] [options]
If specified, OdxSQL will automatically attempt to connect to the Omnidex Environment Filespec. If the Omnidex Environment Filespec is not passed as a program argument, then a CONNECT statement must be performed to establish a connection to the Omnidex Environment. -
Option | Option Description |
---|---|
Omnidex_Environment_filespec | Omnidex Environment |
-help | -? | Display the list cf command line options |
-version | Program version |
-use=filespec | Execute statements in named file |
-cmd='cmd1;cmd2' | Execute specified OdxSQl commands |
-where='criteria' | Apply criteria to use statement |
-exit | Exit after completion of use file |
-exit_on_error | Exit if an error occurs |
-nobanner | Do not print banner |
-cloa | Run OdxSQL using the CLOA client interface |
-odbc | Run ODXsql using the ODBC client interface |
-jdbc | Run ODXsql using the JDBC client interface |
-odxnet[=port] | Launch an OdxNet listener for this session |
Displays a short description of OdxSQL along with a list of the command line options.
The following is a display of the -? option that displays a list of available options.
C:\Program Files\Omnidex 5.0\demo\orders>odxsql -? ODXSQL - Omnidex SQL Sun Nov 29 20:05:38 2009 (c) Dynamic Information Systems Corp. 1981-2009 5.0 Build 1H Microsoft Windows XP Professional SP 3 (2600) TDO830/TDO ** Trial Copy ** Syntax: odxsql [environment] [options] Description: Console program supporting interactive Omnidex SQL statements Options: -help | -? Help -version Program version -use=filename Execute statements in named file -cmd='cmd1;cmd2' Execute specified statements -where='criteria' Apply criteria to use statement -exit Exit after completion of use file -exit_on_error Exit if an error occurs -nobanner Do not print banner -cloa Run odxsql using the CLOA client interface -odbc Run odxsql using the ODBC client interface -jdbc Run odxsql using the JDBC client interface -odxnet[=port] Launch an OdxNet listener for this session C:\Program Files\Omnidex 5.0\demo\orders>
The -use=use_file parameter instructs OdxSql to process all the commands contained within the specified use file. The right hand side of the parameter, use_file, is the filespec of the file containing the commands.
os> odxsql
Use the OdxSQL CONNECT command to connect to an Omnidex Evironment from within OdxSQL.
os> odxsql myenv.xml
os> odxsql -use = mycmds.txt