OdxSQL Commands and Omnidex SQL Statements

OdxSQL Overview	OdxSQL Commands	OdxSQL Settings	OdxSQL Scripts	SQL SELECT	Omnidex SQL

Overview

OdxSQL is used to process a wide range of Omnidex SQL Statements and OdxSQL specific commands.

The OdxSQL Commands and Omnidex SQL Statements are organized for quick review as follows:

Connecting and Disconnecting
Omnidex SQL Data Definition Language (DDL) Statements
Omnidex SQL Data Manipulation Language (DML) Statements | * [[Omnidex Environment Operation Commands | Omnidex Environment Operation Commands | * [[OdxSQl and Omnidex SQL Data Export and Manipulation | OdxSQl and Omnidex SQL Data Export and Manipulation | * [[#OdxSQL Program Operation Commands | OdxSQL Program Operation Commands
OdxSQL Testing and Performance Commands | * [[OdxSQL Operating System Commands | OdxSQL Operating System Commands | * [[Omnidex Index Direct Maintenance Routines | Omnidex Index Direct Maintenance Routines | * [[Alphabetical List of OdxSQL Commands and Omnidex SQL Statements | Alphabetical List of OdxSQL Commands and Omnidex SQL Statements | OdxSQL Commands and Omnidex SQL Statements can be entered into OdxSQL in ether upper or lower case. > connect myenv > CONNECT myenv The syntax for Omnidex SQL Statements entered into OdxSQL or processed in a script file is typically the exact same syntax and returns the exact same results. There are a few exceptions such as CONNECT and VERSION. In OdxSQL, CONNECT has the additional options of ON host:port and USING api that would not make sense in an ODBC or JDBC application. In OdxSQL, the VERSION command displays the OdxSQL header and multiple lines of version information where the Omnidex SQL VERSION statement returns a single line. The OdxSQL EXECSQL command can be used to verify if an Omnidex SQL Statement is processed exactly the same by OdxSQL as the Omnidex SQL parser. <code> > VERSION ODXSQL - Omnidex SQL Wed Dec 02 09:20:41 200 ... Omnidex Version 5.0 Build 2B Compilation Timestamp Oct 13 2009 08:57:09 Earliest Compatible ODBC Client 4.3 Build 4B Earliest Compatible JDBC Client 4.3 Build 4B Earliest Compatible Odx Kernel 5.0 Build 1B > EXECSQL VERSION OmniAccess version 50002 > </code> ===== Connecting and Disconnecting ===== | [[programs:odxsql:commands:connect|CONNECT | Connect to an Omnidex Environment or ODBC/JDBC Datasource File (DSN). |

| DISCONNECT | Disconnect from a previously Connected Omnidex Environment or ODBC or JDBC Datasource (DSN). |

ATTACH	Attach an OST file as a table to the currently connected Omnidex Environment.
DETACH	Detach a previously attached Omnidex Standalone Table (OST) file.

Omnidex SQL Data Definition Language (DDL) Statements

DDL Statement	Description
CREATE ENVIRONMENT	Create an Omnidex Environment.
CREATE DATABASE	Create ad Database within an Omnidex Environment.
CREATE TABLE	Create a Table.
CREATE INDEX	Create Index
CREATE INDEXES	Create Omnidex Indexes.
DROP ENVIRONMENT	Drop Environment.
DROP DATABASE	Drop Database
DROP TABLE	Drop a previously created temporary table.
DROP INDEX	Drop Index.
DROP INDEXES	Drop Indexes.

Omnidex SQL Data Manipulation Language (DML) Statements

SELECT	Issue an Omnidex SQL SELECT Statement.
INSERT	Issue an Omnidex SQL INSERT Statement.
UPDATE	Issue an Omnidex SQL UPDATE Statement.
DELETE	Issue the SQL DELETE Statement.
OPEN CURSOR	Open a Cursor.
ASSIGNVALUES	Assign values for a $VALUES clause to be used in a subsequent SELECT.
JOIN	Join tables using Omnidex Indexes.
QUALIFY	Qualify rows using Omnidex criteria.
DESCRIBE	Describe a SELECT Statement.
BIND	Bind a SELECT Statement.
FETCH	Explicitly fetch data from the database.
FETCHKEYS	Explicitly fetch keys from the Omnidex Indexes.
CLOSE CURSOR	Close a previously opened cursor.

Omnidex Environment Operation Commands

SHOW	Show Omnidex Environment information including Databases, Tables, Column layouts, Query Statistics, etc.
VALIDATE	Validate the Omnidex Environment's view of the underlying data.
PARTITION	Partition a table into smaller sub tables based on criteria.
UPDATE ROLLUP	Update Rollup Table with summarized information.
UPDATE ROLLUPS	Update all Rollup Tables for an Omnidex Database.
UPDATE STATISTICS	Update Statistics Information.
UPDATE TEXT	Update Textual Statistics.
LOOKUP	Lookup Text Metadata and display it.
LOAD OFX	Load Indexes for a table.
HELPER	Access OAHELPER functions for generating Environment Catalogs.
VERSION	Display current Omnidex Software versions.

OdxSQL and Omnidex SQL Data Export and Manipulation

PARTITION	Partition a table into smaller sub tables based on criteria.
CONVERT	Export a file with data conversion.
EXPORT	Export rows to a file.
EXTRACT	Extracts SQL Statements from a table and writes them to a file.

OdxSQL Program Operation Commands

USE	Read and process a file of OdxSQL Commands and Omnidex SQL Statements, optionally with WHERE criteria.
Redo Command ( . )	Execute the last command.
HISTORY	Show the history of OdxSQL Commands and Statements.
n	Execute the numbered OdxSQL History Command or Statement.
EDIT	Edit the current command, a previous command or file using Notepad, vi or a named editor.
SAVE HISTORY	Save the OdxSQL Command History to a file.
RESET HISTORY	Resets the OdxSQL History of Commands and Statements.
SET	Set an OdxSQL setting.
SAVE SETTINGS	Save OdxSQL Settings to a file for use with a later RESTORE SETTINGS Command.
RESTORE SETTINGS	Restore Settings, optionally from a file that was created with a previous SAVE SETTINGS command.
FOR	Execute the next one or more commands the specified number of times.
IF	Form an IF ELIF ELSE ENDIF Construct.
HELP	Show a list of commands help on individual commands, COMMANDS, SYNTAX and API.
IS	Check Table Conditions.
EVAL	Evaluate a condition.
DATE	Show the current Date and Time.
CALC	Perform basic calculator functions.
EXIT	Exit the OdxSQL program.
QUIT	Quit the OdxSQL program. Same as Exit.
Comment ( ; )	Use a semicolon as the first character of a line for a comment line.

OdxSQL Testing and Performance Commands

EXPLAIN	Explain the optimization approach to a previous retrieval.
VALIDATE	Validate the Omnidex Environment's view of the underlying data.
RESET TIMER	Reset the OdxSQL Cummulative Timer.
BENCHMARK	Execute Benchmarks to analyze performance.
EXTRACT	Extracts SQL Statements from a table and writes them to a file.
FORMAT	Format a file of Omnidex SQL Statements.
n:	Send the numbered OdxSQL History Command to a son process.
ERROR	Display the text of an error message from the Omnidex Error Message file.
MESSAGE	Display an Omnidex Environment Message.
EXECSQL
NETWORKACCESS	Execute an Omndiex Network Access Command.
SLEEP	Sleep for a specified number of seconds.
ABORT	Issues an Operating System Abort - used to test abnormal conditions.
SIGNAL	Sends a Signal to a process.
SLEEP	Sleep for a specified number of seconds.
DUMP	Dump files, memory or caches.
OXKERNEL	Execute an Omnidex Kernel Command. Should be used for Debugging with DISC Personnel.
PARSE	Parse an Omnidex SQL Statement to a file. This would only be used by DISC Personnel.
SORTMERGE	Internal: Activates the Sort/Merge Test System.

OdxSQL Operating System Commands

! <shell command>	Run an OS command in the OS Shell and return or just an ( ! ) for an interactive shell.
COMMAND	Execute a shell command via the $COMMAND table.
CD Change Directories	Change Directories in the underlying Operating System.
CREATE DIRECTORY	Create a directory in the underlying Operating System.
PWD	Print (display) the current working directory from the underlying Operating System.
DIR	Display a directory of files from the current directory in the underlying Operating System.
EDIT	Edit a previous command or file by running Notepad or vi or named editor.
COPY	Copy a file or fileset.
CREATE FILE	Create a File in the underlying Operating System.
REMOVE	Remove (delete or purge) one or more files or directories from the underlying Operating System.
RENAME	Rename a file or fileset in the underlying Operating System.
VIEW	View a text file.
SETENV	Set an Operating System Environment Variable.
GETENV	Display an Operating System Environment Variable.
ABORT	Issues an Operating System Abort - used to test abnormal conditions.

Omnidex Index Direct Maintenance Routines

INSERTINDEX	Insert values directly into the Omnidex Indexes.
UPDATEINDEX	Update values directly in the Omnidex Indexes.
DELETEINDEX	Delete values directly from the Omnidex Indexes.

Alphabetical List of OdxSQL Commands and Omnidex SQL Statements

Command	Description
! <shell command>	Run the command in the OS Shell and return or ! for interactive shell
. Redo Command	Execute the last command.
ABORT	Issues an Operating System Abort - used to test abnormal conditions.
ASSIGNVALUES	Assign values for a $VALUES clause to be used in a subsequent SELECT.
ATTACH	Attach an OST file as a table to the currently connected Omnidex Environment.
BENCHMARK	Execute Benchmarks to analyze performance.
BIND	Bind a SELECT Statement.
CALC	Perform basic calculator functions.
CD	Change Directories in the underlying Operating System.
CLOSE CURSOR	Close a previously opened cursor.
COMMAND	Execute a shell command via the $COMMAND table.
Comment ( ; )	Use a semicolon as the first character of a line for a comment line.
CONNECT	Connect to an Omnidex Environment or ODBC/JDBC Datasource File (DSN).
CONVERT	Export a file with data conversion.
COPY	Copy a fileset.
CREATE DATABASE	(V5.1) Create ad Database within an Omnidex Environment.
CREATE DIRECTORY	Create a directory in the underlying Operating System.
CREATE ENVIRONMENT	(V5.1) Create an Omnidex Environment.
CREATE FILE	Create a File in the underlying Operating System.
CREATE INDEX	(V5.1 Create Index
CREATE INDEXES	Create Omnidex Indexes.
CREATE TABLE	(V5.1) Create a Table.
DATE	Show the current Date and Time.
DELETE	Issue the SQL DELETE Statement.
DELETEINDEX	Delete values directly from the Omnidex Indexes.
DESCRIBE	Describe a SELECT Statement.
DETACH	Detach a previously attached Omnidex Standalone Table (OST) file.
DIR	Display a directory of files from the current directory in the underlying Operating System.
DISCONNECT	Disconnect from a previously Connected Omnidex Environment or ODBC or JDBC Datasource (DSN).
DROP DATABASE	Drop Database(V5.1)
DROP ENVIRONMENT	Drop Environment. (V5.1)
DROP INDEX	Drop Index. (V5.1)
DROP INDEXES	Drop Indexes.
DROP TABLE	Drop a previously created temporary table. Expaned in (V5.1)
DUMP	Dump files, memory or caches.
EDIT	Edit a previous command or file.
ERROR	Display the text of an error message from the Omnidex Error Message file.
EVAL	Evaluate a condition.
EXECSQL	Execute an Omnidex SQL Statement directly with the oaexecsql routine without OdxSQL doing any processing.
EXIT	Exit the OdxSQL program.
EXPLAIN	Explain the optimization approach to a previous retrieval.
EXPORT	Export rows to a file.
EXTRACT	Extracts SQL Statements from a table and writes them to a file.
FETCH	Explicitly fetch data from the database.
FETCHKEYS	Explicitly fetch keys from the Omnidex Indexes.
FLIP	Change the endian byte order from one endian to the other.
FOR	Execute the next one or more commands the specified number of times.
FORMAT	Format a file of Omnidex SQL Statements.
GETENV	Display an Operating System Environment Variable.
HELP	Help on COMMANDS, SYNTAX and API.
HELPER	Access OAHELPER functions for generating Environment Catalogs.
HISTORY	Show the history of OdxSQL Commands and Statements.
IF	Form an IF ELIF ELSE ENDIF Construct.
INSERT	Issue an Omnidex SQL INSERT Statement.
INSERTINDEX	Insert values directly into the Omnidex Indexes.
IS	Check Table Conditions.
JOIN	Join tables using Omnidex Indexes.
LOAD OFX	Load Indexes for a table.
LOOKUP	Lookup Text M etadata and display it.
MESSAGE	Display an Omnidex Environment Message.
NETWORKACCESS	Execute an Omndiex Network Access Command.
OPEN CURSOR	Open a Cursor.
OXKERNEL	Execute an Omnidex Kernel Command. Should be used for Debugging with DISC Personnel.
PARSE	Parse an Omnidex SQL Statement to a file. This would only be used by DISC Personnel.
PARTITION	Partition a table into smaller sub tables based on criteria.
PWD	Print (display) the current working directory from the underlying Operating System.
QUALIFY	Qualify rows using Omnidex criteria.
QUIT	Quit the OdxSQL program. Same as Exit.
REMOVE	Remove (delete or purge) one or more files or directories from the underlying Operating System.
RENAME	Rename a file or fileset in the underlying Operating System.
RESET HISTORY	Resets the OdxSQL History of Commands and Statements.
RESET TIMER	Reset the OdxSQL Cummulative Timer.
RESTORE SETTINGS	Restore Settings, optionally from a file that was created with a previous SAVE SETTINGS command.
SAVE HISTORY	Save the OdxSQL Command History to a file.
SAVE SETTINGS	Save OdxSQL Settings to a file for use with a later RESTORE SETTINGS Command.
SELECT	Issue an Omnidex SQL SELECT Statement.
SET	Set an OdxSQL setting.
SETENV	Set an Operating System Environment Variable.
SHOW	Show Omnidex Environment information including Databases, Tables, Column layouts, Query Statistics, etc.
SIGNAL	Sends a Signal to a process.
SLEEP	Sleep for a specified number of seconds.
SORTMERGE	Internal: Activates the Sort/Merge Test System.
UPDATE	Issue an Omnidex SQL UPDATE Statement.
UPDATE INDEXES	Update Omnidex Indexes
UPDATE ROLLUP	Update Rollup Table with summarized information.
UPDATE ROLLUPS	Update all Rollup Tables for an Omnidex Database.
UPDATE STATISTICS	Update Statistics Information.
UPDATE TEXT	Update Textual Statistics.
UPDATEINDEX	Update values directly in the Omnidex Indexes.
USE	Read and process a file of OdxSQL Commands and Omnidex SQL Statements, optionally with WHERE criteria.
VALIDATE	Validate the Omnidex Environment's view of the underlying data.
VERSION	Display current Omnidex Software versions.
VIEW	View a text file.
n	Execute the numbered OdxSQL History Command or Statement.
n:	Send the numbered OdxSQL History Command to the a son process.

Back to top

programs/odxsql/commands/home.1259774079.txt.gz · Last modified: 2016/06/28 22:38 (external edit)

Sitemap Recent Changes