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

Index Manipulation Statements

Miscellaneous Statements

All Statements

Statement	Description
ASSIGNVALUES	Assigns Values
ATTACH	Attach an OST
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.
DELETE	Delete a row or rows of data.
DELETEINDEX	Delete an Omnidex Index value.
DETACH	Detach an Omnidex Standalone Table
DISCONNECT	Disconnect from an Omnidex Environment
DROP DATABASE	Drop a Database within an Omnidex Environment.
DROP ENVIRONMENT	Drop and Omnidex XML Environment and purge the underlying operating system file.
DROP INDEX	Drop an Omnidex Index from an Omnidex XML Environment.
DROP INDEXES ???
DROP TABLE	Drop a table.
EXPORT	Export data.
HELPER	???
INSERT	Insert a row of data.
INSERTINDEX	Insert a value in an Omnidex Index.
JOIN	Join tables
LOAD OFX	Load an OFX file.
OPEN CURSOR	Open a cursor
PARTITION	Partition Data based on criteria.
QUALIFY	Qualify rows using Omnidex criteris.
SELECT	Select data
SET	Set Omnidex SQL processing options.
UPDATE	Update data.
UPDATE INDEXES	populate Omnidex indexes.
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.
VERSION	Retrieve Omnidex Version Information.

Functions

Back to top

dev/sql/overview.1259535351.txt.gz · Last modified: 2016/06/28 22:38 (external edit)

Sitemap Recent Changes