This shows you the differences between two versions of the page.
programs:odxsql:commandline [2009/11/30 03:27] tdo |
programs:odxsql:commandline [2016/06/28 22:38] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | {{page>:top_add&nofooter&noeditbtn}} | ||
- | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
- | ====== OdxSQL Command Line Options ====== | ||
- | Several command line options are available to OdxSQL. | ||
- | |||
- | |||
- | |||
- | ===== Syntax ===== | ||
- | |||
- | odxsql [Omnidex_Environment_Filespec] | ||
- | [options] | ||
- | |||
- | |||
- | ==== Run Time Arguments ==== | ||
- | |||
- | | 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 | | ||
- | |||
- | == 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. | ||
- | |||
- | -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. | ||
- | |||
- | -? or -help | ||
- | |||
- | The following is a display of the -? option that displays a list of available options. | ||
- | |||
- | <code> | ||
- | 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 | ||
- | </code> | ||
- | |||
- | ===== 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 | ||
- | |||
- | |||
- | |||
- | {{page>:bottom_add&nofooter&noeditbtn}} |