This is an old revision of the document!
Statements | Functions | Datatypes | Examples
Omnidex SQL Statements | |
---|---|
Connections | Data Definition |
CONNECT | CREATE ENVIRONMENT |
DISCONNECT | CREATE DATABASE |
SET | CREATE TABLE |
ATTACH | CREATE INDEX |
DETATCH | CREATE INDEX GROUP |
DROP ENVIRONMENT | |
Queries and Exports | DROP DATABASE |
SELECT | DROP TABLE |
EXPORT | DROP INDEX |
OPEN CURSOR | DROP INDEX GROUP |
CLOSE CURSOR | EXTRACT |
. | |
Updates | Maintenance |
INSERT | UPDATE INDEXES |
DELETE | UPDATE ROLLUPS |
UPDATE | UPDATE STATISTICS |
UPDATE TEXT | |
Omnidex Index Queries | PARTITION |
QUALIFY | LOAD OFX |
JOIN | INSTALL INDEXES |
REMOVE INDEXES | |
—————————————————————————————- | ————————————————————————————— |
Omnidex SQL Statement | Statement Description |
---|---|
CONNECT | Connect to an Omnidex Environment. |
DISCONNECT | Disconnect from a connected Omnidex Environment. |
SET | Set Omnidex SQL processing options. |
ATTACH | Attach an Omnidex Standalone Table (OST) to a connected Omnidex Environment for queries and manipulation. |
DETACH | Detach an Omnidex Standalone Table (OST) from a connected Omnidex Environment. |
Queries and Exports | |
SELECT | Peform a Query Specification and SELECT rows. |
EXPORT | Export rows or rowids to an external file. |
OPEN CURSOR | Open a Cursor. |
CLOSE CURSOR | Close a previously opened cursor. |
Updates | |
INSERT | Insert rows into a Table. |
UPDATE | Update rows in a Table. |
DELETE | Delete rows in a Table. |
Index Only Tables | |
QUALIFY | Qualify index counts using Omnidex criteria. |
JOIN | Join tables using Omnidex Indexes. |
DDL | |
CREATE ENVIRONMENT | Create an Omnidex Environment into a named physical operating system file. |
CREATE DATABASE | Create a Database within an Omnidex Environment. |
CREATE TABLE | Create a Table within a Database in the Omnidex metadata or an Omnidex or RDBMS temporary table. |
CREATE INDEX | Specify an Index in the Omnidex metadata but will not physically create the index. |
CREATE INDEX GROUP | Specify an Index Group within the Omnidex metadata. |
DROP ENVIRONMENT | Deletes the Omnidex Metadata Environment by physically deleting the operating system file. |
DROP DATABASE | Remove the named Database from the Omnidex metadata. |
DROP TABLE | Remove a table from the Omnidex metadata or deletes a previously created temporary table. |
DROP INDEX | Removes an index from the Omnidex metadata. |
DROP INDEX GROUP | Removes a named Index Group from the Omnidex metadata. |
ATTACH | Attach an Omnidex Standalone Table (OST) to a connected Omnidex Environment for queries and manipulation. |
DETACH | Detach an Omnidex Standalone Table (OST) from a connected Omnidex Environment. |
Index Maintenance | |
UPDATE INDEXES | Update Omnidex Indexes. |
UPDATE ROLLUP TABLE | 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. |
PARTITION | Partition a table into smaller sub tables based on criteria. |
LOAD OFX | Load Indexes for a table. |
INSTALL INDEXES | Specifies the Omnidex indexes into the Omnidex XML Environment. No indexing is performed. |
REMOVE INDEXES | Removes the Omnidex indexes from the Omnidex XML Environment. |
Omnidex SQL Statements | ||
---|---|---|
Connections | Omnidex Index Queries | Data Definition |
CONNECT | QUALIFY | CREATE ENVIRONMENT |
DISCONNECT | JOIN | CREATE DATABASE |
SET | CREATE TABLE | |
Maintenance | CREATE INDEX | |
Queries and Exports | UPDATE INDEXES | CREATE INDEX GROUP |
SELECT | UPDATE ROLLUPS | DROP ENVIRONMENT |
EXPORT | UPDATE STATISTICS | DROP DATABASE |
OPEN CURSOR | UPDATE TEXT | DROP TABLE |
CLOSE CURSOR | PARTITION | DROP INDEX |
LOAD OFX | DROP INDEX GROUP | |
Updates | INSTALL INDEXES | ATTACH |
INSERT | REMOVE INDEXES | DETATCH |
DELETE | EXTRACT | |
UPDATE | ||
———————————————————- | ——————————————————— | ———————————————————- |