This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:statements:home [2009/12/08 04:12] tdo |
dev:sql:statements:home [2012/10/26 14:28] (current) |
||
|---|---|---|---|
| Line 34: | Line 34: | ||
| | [[dev:sql:statements:qualify:home|QUALIFY]] | Qualify rows using Omnidex criteria. | | | [[dev:sql:statements:qualify:home|QUALIFY]] | Qualify rows using Omnidex criteria. | | ||
| | [[dev:sql:statements:close_cursor:home|CLOSE CURSOR]] | Close a previously opened cursor. | | | [[dev:sql:statements:close_cursor:home|CLOSE CURSOR]] | Close a previously opened cursor. | | ||
| - | |||
| - | |||
| ===== Omnidex SQL Miscellaneous Statements ===== | ===== Omnidex SQL Miscellaneous Statements ===== | ||
| | [[dev:sql:statements:partition:home|PARTITION]] | Partition a table into smaller sub tables based on criteria. | | | [[dev:sql:statements:partition:home|PARTITION]] | Partition a table into smaller sub tables based on criteria. | | ||
| Line 43: | Line 41: | ||
| | [[dev:sql:statements:home:update_text|UPDATE TEXT]] | Update Textual Statistics. | | | [[dev:sql:statements:home:update_text|UPDATE TEXT]] | Update Textual Statistics. | | ||
| | [[dev:sql:statements:home:load ofx|LOAD OFX]] | Load Indexes for a table. | | | [[dev:sql:statements:home:load ofx|LOAD OFX]] | Load Indexes for a table. | | ||
| - | | [[dev:sql:statements:version:home|VERSION]] | Display current Omnidex Software versions. | | ||
| ===== Alphabetical List of Omnidex SQL Statements ===== | ===== Alphabetical List of Omnidex SQL Statements ===== | ||
| Line 49: | Line 46: | ||
| | [[dev:sql:attach|ATTACH]] | Attach an Omnidex Standalone Table (OST) to a connected Omnidex Environment for queries and manipulation. | | | [[dev:sql:attach|ATTACH]] | Attach an Omnidex Standalone Table (OST) to a connected Omnidex Environment for queries and manipulation. | | ||
| | [[dev:sql:close_cursor|CLOSE CURSOR]] | Close a previously opened cursor. | | | [[dev:sql:close_cursor|CLOSE CURSOR]] | Close a previously opened cursor. | | ||
| - | | [[dev:sql:command|OS Command]] | Execute an Operating System command. | | + | | [[dev:sql:command| COMMAND]] | Execute an Operating System command. | |
| | [[dev:sql:connect|CONNECT]] | Connect to an Omnidex Environment. | | | [[dev:sql:connect|CONNECT]] | Connect to an Omnidex Environment. | | ||
| | [[dev:sql:create_database|CREATE DATABASE]] | Create a Database within an Omnidex Environment. | | | [[dev:sql:create_database|CREATE DATABASE]] | Create a Database within an Omnidex Environment. | | ||
| Line 82: | Line 79: | ||
| | [[dev:sql:update_text|UPDATE TEXT]] | Update Omnidex Text information. | | | [[dev:sql:update_text|UPDATE TEXT]] | Update Omnidex Text information. | | ||
| | [[dev:sql:updateindex|UPDATEINDEX]] | Update Omnidex Index values directly. | | | [[dev:sql:updateindex|UPDATEINDEX]] | Update Omnidex Index values directly. | | ||
| - | | [[dev:sql:version|VERSION]] | Retrieve the Omnidex Version from the currently running library. | | + | | [[dev:sql:version|VERSION]] | Retrieve the Omnidex Version from the currently running library. FIXME Doesn't work in ODBC or JDBC - Remove? | |
| {{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||