|
Utilities |
ODXSQL |
ODXSQL |
OverviewOdxSql is an Omnidex interactive SQL utility used for testing installations, prototyping queries, and exporting data. OdxSql supports many functions designed to assist in creating fully optimized installations and queries including benchmarking and the explain plan. OdxSql allows the interactive specification of SQL statements using supported SQL 92 syntax. OdxSql also fully supports the Omnidex Query Language as well as several additional functions exclusive to OdxSql. Run OdxSql from the command line with the following syntax: odxsql [environment_name] | [-use=use_file]
Directivesenvironment_name -use=use_file
Exampleodxsql or odxsql orders.env or odxsql -use=commands.txt
Getting HelpType help at the command prompt with no arguments to see an alphabetical list of ODXSQL commands. >help Type help with the argument 'syntax' at the command prompt to see a list of commands with their syntax. >help syntax Type help followed by a specific command to see additional information about that command. >help connect CONNECT See HELP in the ODXSQL
Commands section for more information. |
|
DBINSTAL | DSEDIT | OACOMP | OAHELPER | ODXNET | ODXSQL | Utilities |
NSADMIN |
OADECOMP |
ODXAIM |
ODXMAKE |
ODXQUERY |
REGMAINT |
REGTEST |
SNOWGEN |
SYSINFO |
VERSIONS |
VIEWGEN |