DRAFT

Omnidex SQL Reference

Omnidex SQL: Overview Statements Functions Examples Quick Ref
OdxSQL: Overview Commands Settings Command Line Quick Ref

Omnidex SQL Data Definition 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 routines.

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 SQL Data Definition Language (DDL) Statements

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.

Omnidex Detailed DML Statements

OPEN CURSOR Open a Cursor.
JOIN Join tables using Omnidex Indexes.
QUALIFY Qualify rows using Omnidex criteria.
CLOSE CURSOR Close a previously opened cursor.

Omnidex SQL Miscellaneous Statements

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.

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 DIRECTORY Create a Directory in the underlying operating system.
CREATE ENVIRONMENT Create an Omnidex Environment.
CREATE FILE Create a file in the underlying operating system.
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. FIXME Doesn't work in ODBC or JDBC - Remove?