OdxSQL Command Line Options

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

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