This is an old revision of the document!
DRAFT
Omnidex SQL Reference
The following Omnidex SQL Statements can be used by OdxSQL or and ODBC or JDBC application.
Omnidex SQL Data Management Language (DDL) Statements
Omnidex SQL supports SQL's main Data Manipulation Statements (SELECT, INSERT, UPDATE, and DELETE) as well as several lower level Omnidex SQL statements.
SELECT | Peform a Query Specification and SELECT rows. |
INSERT | Insert rows into a Table. |
UPDATE | Update rows in a Table. |
DELETE | Delete rows in a Table. |
Omnidex Connection Statements
CONNECT | Connect to an Omnidex Environment. |
DISCONNECT | Disconnect from a connected Omnidex Environment. |
SET | Set Omnidex SQL processing options. |
Omnidex SQL Data Definition Language (DDL) Statements
Omnidex SQL has statements that create and drop objects within an Omnidex Environment.
Omnidex Cursor and Index Statements
Omnidex SQL Miscellaneous Statements
Alphabetical List of Omnidex SQL Statements
Statement | Description |
ATTACH | Attach an Omnidex Standalone Table (OST) to a connected Omnidex Environment for queries and manipulation. |
CLOSE CURSOR | Close a previously opened cursor. |
COMMAND | Execute an Operating System command. |
CONNECT | Connect to an Omnidex Environment. |
CREATE DATABASE | Create a Database within an Omnidex Environment. |
CREATE ENVIRONMENT | Create an Omnidex Environment. |
CREATE INDEX | Create an Index. |
CREATE TABLE | Create a table within an Omnidex Environment or create a temp table in the underlying RDBMS. |
DELETE | Delete a row or rows of data. |
DETACH | Detach an Omnidex Standalone Table (OST) from a connected Omnidex Environment. |
DISCONNECT | Disconnect from a connected Omnidex Environment. |
DROP DATABASE | Drop a Database from within an Omnidex Environment. |
DROP ENVIRONMENT | Drop an Omnidex XML Environment and purge the underlying operating system file. |
DROP INDEX | Drop an Omnidex Index. |
DROP TABLE | Drop a table created with a CREATE TABLE or SELECT INTO statement. |
EXPORT | Export rows or rowids to an external file. |
INSERT | Insert a row of data. |
JOIN | Manually join two tables for a joined query |
LOAD OFX | Load an OFX file. |
OPEN CURSOR | Open a cursor. |
PARTITION | Partition Data based on criteria. |
QUALIFY | Qualify rows in a query. Typically superseded by SELECT |
SELECT | Select rows , aggregate rows, using Omnidex enhanced criteria. |
SET | Set Omnidex SQL processing options. |
UPDATE | Update rows in a table. |
UPDATE INDEXES | Update all Omnidex Indexes. |
UPDATE ROLLUP | Update Rollup Tables with new calculations. |
UPDATE ROLLUPS | Update all Rollup Tables with new calculations. |
UPDATE STATISTICS | Update the Omnidex Statistics information. |
UPDATE TEXT | Update Omnidex Text information. |