OdxSQL Command Line Options

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.

Syntax

odxsql [Omnidex_Environment_Filespec] 
       [options]

Omnidex Environment Filespec

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. -

Other Options

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

-? or -help

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>

-use=use_filespec

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.

 os> odxsql

Use the OdxSQL CONNECT command to connect to an Omnidex Evironment from within OdxSQL.

Specifying an Omnidex Environment Filespec.

os> odxsql myenv.xml

Specifying a file of OdxSQL commands.

os> odxsql -use = mycmds.txt

Back to top

programs/odxsql/commandline.1259553618.txt.gz · Last modified: 2016/06/28 22:38 (external edit)

Sitemap Recent Changes