Omnidex SQL Reference

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.

    | [[dev:sql:assignvalues|ASSIGNVALUES]] |mAssigns Values |
    | [[dev:sql:attach|ATTACH]] | Attach an OST |              
    | [[dev:sql:close_cursor|CLOSE CURSOR]] | Closes a cursor |
    | [[dev:sql:command|command]] | Issue an operating system command |
    | [[dev:sql:connect|CONNECT]] | Connect to an Omnidex Environment |
    | [[dev:sql:create_database|CREATE DATABASE]] | Create a Database |
    | [[dev:sql:create_directory|CREATE DIRECTORY]] | Create a Directory in the underlying operating system. |
    | [[dev:sql:create_environment|CREATE ENVIRONMENT]] | Create an Omnidex XML Environment |
    | [[dev:sql:create_file|CREATE FILE]] | Create a file in the underlying operating system. |
    | [[dev:sql:create_index|CREATE INDEX]] | Create an Index. |
    | [[dev:sql:create_indexes|CREATE INDEXES]] | ??? |
    | [[dev:sql:create_table|CREATE TABLE]] | Create a table within an Omnidex XML Environment. |
    | [[dev:sql:delete|DELETE]] | Delete a row or rows of data. |
    | [[dev:sql:deleteindex|DELETEINDEX]] | Delete an Omnidex Index value. |
    | [[dev:sql:detach|DETACH]] | Detach an Omnidex Standalone Table |
    | [[dev:sql:disconnect|DISCONNECT]] |  Disconnect from an Omnidex Environment |
    | [[dev:sql:drop_database|DROP DATABASE]] | Drop a Database within an Omnidex Environment. |
    | [[dev:sql:drop_environment|DROP ENVIRONMENT]] | Drop and Omnidex XML Environment and purge the underlying operating system file. |
    | [[dev:sql:drop_index|DROP INDEX]] | Drop an Omnidex Index from an Omnidex XML Environment. |
    | [[dev:sql:drop_indexes|DROP INDEXES]] ??? |
    | [[dev:sql:drop_table|DROP TABLE]] | Drop a table. |
    | [[dev:sql:export|EXPORT]] | Export data. |
    | [[dev:sql:helper|HELPER]] | ??? |
    | [[dev:sql:insert|INSERT]] | Insert a row of data. |
    | [[dev:sql:insertindex|INSERTINDEX]] | Insert a value in an Omnidex Index. |
    | [[dev:sql:join|JOIN]] | Join tables |
    | [[dev:sql:load_ofx|LOAD OFX]] | Load an OFX file. |
    | [[dev:sql:open_cursor|OPEN CURSOR]] | Open a cursor |
    | [[dev:sql:partition|PARTITION]] | Partition Data based on criteria. |
    | [[dev:sql:qualify|QUALIFY]] | Qualify rows using Omnidex criteris. |
    | [[dev:sql:select|SELECT]] | Select data |
    | [[dev:sql:set|SET]] | Set Omnidex SQL processing options. |
    | [[dev:sql:update|UPDATE]] | Update data. |
    | [[dev:sql:update_indexes|UPDATE INDEXES]] | populate Omnidex indexes. |
    | [[dev:sql:update_rollup|UPDATE ROLLUP]] | Update Rollup Tables with new calculations. |
    | [[dev:sql:update_rollups|UPDATE ROLLUPS]] | ??? |
    | [[dev:sql:update_statistics|UPDATE STATISTICS]] | Update the Omnidex Statistics information. |
    | [[dev:sql:update_text|UPDATE TEXT]] Update Text information. |
    | [[dev:sql:updateindex|UPDATEINDEX]] | Update Omnidex Index Information. |
    | [[dev:sql:version|VERSION]] | Retrieve Omnidex Version Information. |