Statements | Functions | Datatypes | Examples
| Omnidex SQL Statements | |
|---|---|
| Connections | Data Definition |
| CONNECT | CREATE ENVIRONMENT |
| DISCONNECT | CREATE DATABASE |
| SET | CREATE TABLE |
| ATTACH | CREATE INDEX |
| DETACH | 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 Statements can be issued through any standard ODBC and JDBC connection, and through the OdxSQL program.
| Statement | Description |
|---|---|
| Connections | |
| 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 File. |
| 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. |
| Omnidex Index Queries | |
| QUALIFY | Qualify index counts using Omnidex criteria. |
| JOIN | Join tables using Omnidex Indexes. |
| Data Definition | |
| 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. |
| 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. |