This shows you the differences between two versions of the page.
|
programs:odxsql:commandline [2009/11/30 03:55] 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 ====== | ||
| - | 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. | ||
| - | |||
| - | <code> | ||
| - | 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> | ||
| - | </code> | ||
| - | |||
| - | == -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 | ||
| - | |||
| - | |||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||