This is an old revision of the document!
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.
SELECT | Select data |
INSERT | Insert data |
DELETE | Delete data |
UPDATE | Update data |
QUALIFY | Qualify rows using Omnidex criteria |
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 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 a value in an Omnidex Index. |
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. |