This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:home [2009/12/03 19:10] tdo |
dev:sql:home [2012/10/26 14:26] (current) |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| ~~NOTOC~~ | ~~NOTOC~~ | ||
| ====== Omnidex SQL Quick Reference ====== | ====== Omnidex SQL Quick Reference ====== | ||
| - | ^[[ dev:sql:overview |Overview]]^ [[ dev:sql:statements:home | Statements]] ^[[dev:sql:functions:home | Functions ]]^ [[ dev:sql:select | SELECT^ [[ nopage | Query Examples ]]^ | + | {{page>:sql_bar&nofooter&noeditbtn}} |
| + | |||
| + | |||
| + | ===== Most Common Statements ===== | ||
| + | |||
| + | * SELECT | ||
| + | * CREATE TABLE | ||
| + | * CREATE INDEX | ||
| + | |||
| + | ===== SQL Interfaces ===== | ||
| + | |||
| + | * JDBC | ||
| + | * ODBC | ||
| + | * Stored Procedures | ||
| + | |||
| + | ===== Omnidex SQL Tips ===== | ||
| SQL is the preferred way to access Omnidex enhanced data. | SQL is the preferred way to access Omnidex enhanced data. | ||
| Line 10: | Line 25: | ||
| Getting Counts. | Getting Counts. | ||
| + | ===== Learning Omnidex ===== | ||
| + | * [[ tutorials:simple_flatfile | Creating a very simple flat file Environment and doing retrievals. ]] | ||
| + | * [[ tutorials:simple_flatfile_java_JDBC | Writing a simple JDBC program to access the simple flatfile Environment. ]] | ||
| + | * [[ tutorials:simple_flatfile_cpp_ODBC | Writing a simple ODBC program to access the simple flatfile Environment. ]] | ||
| + | * [[ tutorials:simple_flatfile_EXCEL | Using EXCEL to access Omnidex Environments with the ODBC Driver. ]] | ||
| + | |||
| + | ===== Special Omnidex SQL tokesns ===== | ||
| + | |||
| + | $omnidex - special table of one row and one column. Good to test functions, etc. | ||
| + | |||
| + | $uniquekey - | ||
| + | |||
| + | $ROWID - | ||
| - | ODBC | + | ===== See Also ===== |
| - | JDBC | + | |
| - | $omnidex | + | Omnidex SQL Statements |
| - | $uniquekey | + | |
| Standard SQL Functions | Standard SQL Functions | ||