This is an old revision of the document!


Omnidex SQL Statement Quick Reference

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.
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.

Omnidex SQL Index and Processing Maintenance Statements

Omnidex supports several statements to synchronize the Omnidex indexes, rollup tables and internal statistics.

UPDATE INDEXES Update Omnidex Indexes.
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.
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 Index Query Statements

Omnidex supports lower level QUALIFY and JOIN statements to query the Omnidex indexes directly. These statements are advanced statements used for testing and to support legacy applications. The SELECT statement is now typically used instead.

QUALIFY Qualify index counts using Omnidex criteria.
JOIN Join tables using Omnidex Indexes.
















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
———————————————————-——————————————————————————————————————-




























 
Back to top
dev/sql/home.1278633680.txt.gz · Last modified: 2016/06/28 22:38 (external edit)