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