Omnidex SQL Reference

QuickLinks	Statements	Functions	OdxSQL

The following Omnidex SQL Statements can be used by OdxSQL or and ODBC or JDBC application.

Omnidex SQL SELECT and Update Statements

Omnidex SQL supports SQL's main Data Manipulation Statements (SELECT, INSERT, UPDATE, and DELETE) as well as several lower level Omnidex SQL statements.

SELECT	Peform a Query Specification and SELECT rows.
INSERT	Insert rows into a Table.
UPDATE	Update rows in a Table.
DELETE	Delete rows in a Table.

Omnidex Connection Statements

CONNECT	Connect to an Omnidex Environment.
DISCONNECT	Disconnect from a connected Omnidex Environment.
SET	Set Omnidex SQL processing options.

Omnidex SQL Data Definition Language (DDL) Statements

Omnidex SQL has statements that create and drop objects within an Omnidex Environment.

DDL Statement	Description
CREATE ENVIRONMENT	Create an Omnidex Environment.
CREATE DATABASE	Create a Database within an Omnidex Environment.
CREATE TABLE	Create a Table.
CREATE INDEX	Create Index
CREATE INDEX GROUP	Create an Index Group.
DROP ENVIRONMENT	Drop Environment.
DROP DATABASE	Drop Database
DROP TABLE	Drop a previously created temporary table.
DROP INDEX	Drop Index.
DROP INDEX GROUP	Drop Index Group.
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.
EXTRACT	Extract DDL statements

Omnidex SQL Query and Export Statements

OPEN CURSOR	Open a Cursor.
CLOSE CURSOR	Close a previously opened cursor.

Omnidex SQL Index Query Statements

JOIN	Join tables using Omnidex Indexes.
QUALIFY	Qualify rows using Omnidex criteria.

Omnidex SQL Maintenance Statements

PARTITION	Partition a table into smaller sub tables based on criteria.
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.
LOAD OFX	Load Indexes for a table.

Alphabetical List of Omnidex SQL Statements

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 ENVIRONMENT	Create an Omnidex Environment.
CREATE INDEX	Create an Index.
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 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. Typically superseded by SELECT
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.

Back to top

dev/sql/statements/home.1275685912.txt.gz · Last modified: 2016/06/28 22:38 (external edit)

Sitemap Recent Changes