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 04:11] tdo |
dev:sql:overview [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 2: | Line 2: | ||
<html><div align="center"><span style="color:red">DRAFT</span></div></html> | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
====== Omnidex SQL Reference ====== | ====== Omnidex SQL Reference ====== | ||
+ | {{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. |