Omnidex SQL Quick Reference

• SELECT
• CREATE TABLE
• CREATE INDEX

• JDBC
• ODBC
• Stored Procedures

SQL is the preferred way to access Omnidex enhanced data.
 
Use SELECT over QUALIFY whenever possible.

Getting Counts.

• Creating a very simple flat file Environment and doing retrievals.
• Writing a simple JDBC program to access the simple flatfile Environment.
• Writing a simple ODBC program to access the simple flatfile Environment.
• Using EXCEL to access Omnidex Environments with the ODBC Driver.

$omnidex - special table of one row and one column.  Good to test functions, etc.

$uniquekey - 

$ROWID -

Omnidex SQL Statements

Standard SQL Functions

Omnidex Extended Functions