Omnidex SQL Reference

QuickLinks	Statements	Functions	OdxSQL

Omnidex SQL Data Definition Language (DDL) Statements

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

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 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 ad Database within an Omnidex Environment.
CREATE TABLE	Create a Table.
CREATE INDEX	Create Index
CREATE INDEX GROUP	Create an Index Group.
CREATE INDEXES	Create Omnidex Indexes.
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.
DROP INDEXES	Drop Indexes.

Omnidex Detailed DML Statements

OPEN CURSOR	Open a Cursor.
JOIN	Join tables using Omnidex Indexes.
QUALIFY	Qualify rows using Omnidex criteria.
CLOSE CURSOR	Close a previously opened cursor.

Omnidex SQL Miscellaneous 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 INDEXES	Create all Omnidex Indexes
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 INDEXES	Drop all Omnidex Indexes.
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.
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.
UPDATEINDEX	Update Omnidex Index values directly.
VERSION	Retrieve the Omnidex Version from the currently running library. Doesn't work in ODBC or JDBC - Remove?

Back to top

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

Sitemap Recent Changes