This is an old revision of the document!


DRAFT

Omnidex SQL Quick Reference

Omnidex SQL Statements and OdxSQL Commands

Omnidex SQL Standard Functions

Omnidex Extended Functions

Oracle Functions

SETTINGS that affect SQL

SET SET SQL_SYNTAX=<ORACE|OMNIDEX|SQLSERVER> Allow Oracle functions and SqlServer bracket syntax.
OdxSQL SET TERMINATION [ ON | OFF ] Set auto termination of statements.

Create a simple functioning Environment with an Omnidex index

os> odxsql
> CREATE ENVIRONMENT IN "myenv.xml";
> CREATE DATABASE mydb TYPE FLATFILE IN "myenv.xml";
> CREATE TABLE mytable PHYSICAL "test1" 
       (myseq integer, mytext char(60) quicktext) 
       IN "myenv.xml";
> CONNECT myenv.xml;
> UPDATE INDEXES;
> SELECT * FROM mytable where mytext = '<some criteria>';
> DISCONNECT;
> EXIT
os>

Learning Omnidex

Special Omnidex SQL tokens

$omnidex special table of one row and one column. Good to test functions, etc.
$uniquekey
$ROWID
 
Back to top
dev/sql/home.1278197319.txt.gz ยท Last modified: 2016/06/28 22:38 (external edit)