Omnidex SQL Statement Quick Reference

Omnidex SQL Statement Descriptions

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.
 
Back to top
dev/sql/home.txt ยท Last modified: 2020/11/30 18:42 by doc