This is an old revision of the document!
Command Line Options | Description |
---|---|
odxsql | Run OdxSQL. Use the CONNECT command to connect to an Omnidex Environment |
odxsql env_filespec | Run OdxSQL and connect to the env_filespec. |
odxsql dsn_filespec -odxnet -odbc | Run OdxSQL and an OdxNET background process and connect to the ODBC File DSN using ODBC |
odxsql -? | Displays OdxSQL command line options |
odxsql -use scriptfile | Run OdxSQL and read and process the scriptfile of OdxSQL Statements and Commands. |
OdxSQL is a console application for manually entering Omnidex SQL Statements and OdxSQL Commands or for processing scripts of Omnidex SQL statements.
Use OdxSQL for processing Omnidex SQL Data Definition Scripts to create Omnidex Environments and Indexes.
Use OdxSQL to test Omnidex SQL SELECTs and ODBC, JDBC and Network Services set up.
Use OdxSQL to prototype Omnidex Queries and use the Explain Command to review optimization.
Use OdxSQL on a client computer to access an Omnidex Environment on a remote server via OdxNet to test network response times.
os> odxsql os> odxsql envfile os> odxsql dsnfile -odxnet -odbc os> odxsql -? os> odxsql -use scriptfile
Running OdxSQL Explained:
odxsql | Run OdxSQL. Use the CONNECT command to connect to an Omnidex Environment |
odxsql envfile | Run OdxSQL and connect to the 'envfile' |
odxsql dsnfile -odxnet -odbc | Run OdxSQL and an OdxNET background process and connect to the DSN using ODBC |
odxsql -? | Displays OdxSQL command line options |
odxsql -use scriptfile | Run OdxSQL and read and process the scriptfile of OdxSQL Statements and Commands. |
Set Command | Description |
---|---|
SET | Shows the current settings. |
SET ? | Shows the list of available SET options. |
SET TERMINATION OFF | Will Automatically terminate SQL Statements. |
Help/Show | Description |
---|---|
HELP | Shows a list of OdxSQL commands and SQL Statements. |
HELP <COMMAND> | Provides specific help on the specified command or SQL Statement. |
SHOW <table> | Provides information on the specified table. |
SHOW ALL | Provides information on all tables. |
Internal x [AUTOPSEUDOCOLUMNS <ON | OFF>] x [AUTORECONNECT <ON | OFF>] x [AUTOSUBPROCESS <n | NONE> x [STATISTICS_COMMENT "string"] x [PREPROCESSOR <ON | OFF>] x [PROGRESS <ON | OFF>] x [MEMORY_BASELINE] x [FILE_BASELINE]
SET DEBUG … SET OPTIMIZATION … SET REQUIRED_OPTIMIZATION SET CHAR … SET TIMEOUT … SET REDEFROWIDS … SET PSEUDOCOLUMNS … SET QUALIFY_MODE <ODXFIND | PARSER > SET AUTOPSEUDOCOLUMNS … SET PREPROCESSOR … SET SQL_LOGGING … SET SQL_LOGFILE …
The syntaxes of the SQL Logging SET commands are shown below:
set sql_logging <on | off>
This command activates SQL Logging for this process. By default, statements are logged to the $SQL_STATEMENTS file along with statistics about the execution of the command. The $SQL_STATEMENTS file is named “sqllog.tdf”, and is located in the same directory as the compiled environment file. This file is a standard tab-delimited file, and may be easily imported into other applications. The file may be flushed by simply removing the file; the file will be automatically recreated the next time logging is activated.
set sql_logfile <filename>
This command redirects the SQL logging for this process to a text file that only contains the statement, and does not contain any statistical information. If the file already exists, it will be appended to rather than overwritten.