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 | 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. |