This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:overview [2009/12/04 06:16] tdo |
dev:sql:overview [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| ====== Omnidex SQL Reference ====== | ====== Omnidex SQL Reference ====== | ||
| {{page>:sql_bar&nofooter&noeditbtn}} | {{page>:sql_bar&nofooter&noeditbtn}} | ||
| - | |||
| ===== Overview ===== | ===== Overview ===== | ||
| + | |||
| + | Omnidex SQL is based on ANSI SQL, but also contains extensions that support Omnidex's extended features. | ||
| + | |||
| + | Omnidex has limited support for Oracle and SQL Server specific SQL extensions such as Oracle decode. | ||
| + | |||
| + | Omnidex SQL is available using standard ODBC and JDBC connections. | ||
| Omnidex provides a high-level SQL interface to access databases enhanced with Omnidex indexes. The SQL supported is a subset of the ANSI SQL2 and ANSI SQL99 standard along with some very powerful extensions specific to Omnidex. | Omnidex provides a high-level SQL interface to access databases enhanced with Omnidex indexes. The SQL supported is a subset of the ANSI SQL2 and ANSI SQL99 standard along with some very powerful extensions specific to Omnidex. | ||
| Line 20: | Line 25: | ||
| Omnidex SQL statements can also be tested and scripted using the [[programs:odxsql:overview|OdxSQL]] program. | Omnidex SQL statements can also be tested and scripted using the [[programs:odxsql:overview|OdxSQL]] program. | ||
| - | ===== Omnidex Statements ===== | ||
| - | ===== Omnidex Functions ===== | ||
| - | |||
| - | |||
| - | |||
| {{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||