This is an old revision of the document!
Several command line options are available to OdxSQL.
The following is a display of the -? option that displays a list of available options.
odxsql [Omnidex_Environment_Filespec] [options]
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
Omnidex_Environment_filespec | Omnidex Environment |
-help | -? | Help |
-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 |
XML Catalog or Environment Catalog The environment_name parameter is the environment catalog filespec that OdxSql will connect to. OdxSql will try to connect to the specified environment. If this filespec is not passed as a program argument, then a CONNECT statement must be performed to establish a connection to the environment catalog.
-use=use_file 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.
Examples:
Running OdxSQL without command line arguments - use the CONNECT command to connect to an XML or Environment Catalog.
os> odxsql
Running OdxSQL with in Environment Catalog.
os> odxsql orders.env
Running OdxSQL with a command file of OdxSQL commands.
os> odxsql -use=commands.txt