This is an old revision of the document!
The following Omnidex SQL Statements can be used by OdxSQL or and ODBC or JDBC application.
Omnidex SQL supports SQL's main Data Manipulation Statements (SELECT, INSERT, UPDATE, and DELETE) as well as several lower level Omnidex SQL routines.
Omnidex SQL has statements that create and drop objects within an Omnidex Environment.
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 INDEX GROUP | Create an Index Group. |
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 INDEX GROUP | Drop Index Group. |
DROP INDEXES | Drop Indexes. |
OPEN CURSOR | Open a Cursor. |
JOIN | Join tables using Omnidex Indexes. |
QUALIFY | Qualify rows using Omnidex criteria. |
CLOSE CURSOR | Close a previously opened cursor. |
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. |
LOAD OFX | Load Indexes for a table. |
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 INDEXES | Create all Omnidex Indexes |
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 INDEXES | Drop all Omnidex Indexes. |
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. |
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. |
UPDATEINDEX | Update Omnidex Index values directly. |
VERSION | Retrieve the Omnidex Version from the currently running library. Doesn't work in ODBC or JDBC - Remove? |