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. Doesn't work in ODBC or JDBC - Remove? |