Omnidex SQL Reference

Overview

Omnidex SQL is a rich implementation of the SQL2 and SQL99 standards along with extensions specific to Omnidex.

Omnidex SQL statements can be tested and scripted using the ODXSQL program.

Statements by Type

Data Manipulation Statements

SELECT	Select data
INSERT	Insert data
DELETE	Delete data
UPDATE	Update data
QUALIFY	Qualify rows using Omnidex criteria

Data Definition Language Statements

Index Manipulation Statements

Miscellaneous Statements

All Statements

Statement	Description
ASSIGNVALUES	Use an undetermined set of values as criteria in a query.
ATTACH	Attach an Omnidex Standalone Table (OST) to a connected Omnidex Environment for queries and manipulation.
CLOSE CURSOR	Closes a cursor
command	Issue an operating system command
CONNECT	Connect to an Omnidex Environment
CREATE DATABASE	Create a Database
CREATE DIRECTORY	Create a Directory in the underlying operating system.
CREATE ENVIRONMENT	Create an Omnidex XML Environment
CREATE FILE	Create a file in the underlying operating system.
CREATE INDEX	Create an Index.
CREATE INDEXES	???
CREATE TABLE	Create a table within an Omnidex XML Environment or create a table in the underlying RDBMS.
DELETE	Delete a row or rows of data.
DELETEINDEX	Delete an Omnidex Index value.
DETACH	Detach an Omnidex Standalone Table (OST) from a connected Omnidex Environment.
DISCONNECT	Disconnect from a connected Omnidex Environment.
DROP DATABASE	V5.1 Drop a Database from within an Omnidex Environment.
DROP ENVIRONMENT	V5.1 Drop an Omnidex XML Environment and purge the underlying operating system file.
DROP INDEX	V5.1
DROP INDEXES	???
DROP TABLE	Drop a table created with a CREATE TABLE or SELECT INTO statement.
EXPORT	Export rows or rowids to an external file.
HELPER	???
INSERT	Insert a row of data.
INSERTINDEX	Insert values directly into the Omnidex indexes.
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	V5.1
UPDATE ROLLUP	Update Rollup Tables with new calculations.
UPDATE ROLLUPS	???
UPDATE STATISTICS	Update the Omnidex Statistics information.
UPDATE TEXT	Update Text information.
UPDATEINDEX	Update Omnidex Index Information directly.
VERSION	Retrieve Omnidex Version Information.

Functions

Back to top

dev/sql/overview.1259545684.txt.gz · Last modified: 2012/10/26 14:25 (external edit)

Sitemap Recent Changes