Show pagesource
Old revisions

This is an old revision of the document!

DRAFT

Omnidex SQL Quick Reference

QuickLinks Statements Functions OdxSQL

Omnidex SQL Statements and OdxSQL Commands

DML Select Insert Delete Update Qualify
Access Connect Disconnect Attach Detach Set
DDL Create Create Environment Create Database Create Table Create Index Create Index Group
DDL Drop Drop Environment Drop Datebase Drop Table Drop Index Drop Index Group
Syncing Update Indexes Update Text Update Statistics Update Rollups Update Rollup
Special Export Partition Join Open Cursor Close Cursor
Other Install Indexes Remove Indexes Load OFX Command Extract

Omnidex SQL Standard Functions

ABS CASE CAST CHAR[ACTER]_LENGTH COALESCE || (Concatenation)
CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER EXTRACT LOWER
MOD POSITION POWER ROUND SAMPLE SUBSTRING
SESSION_USER SYSTEM_USER TRIM TRUNC UPPER USER

Omnidex Extended Functions

$CALC_DATE $COL[UMN]_LENGTH $CONTAINS $CONTEXT $CONVERT $COMPARE_DATES
$CURRENT_ROW $DISTANCE $EXTERNAL $HIGHLIGHT_CRITERIA $HIGHLIGHT_KEYWORDS $IFNULL
$LJ $LOOKUP $LPAD $MOD $PROPER $RANDOM
$RJ $RPAD $SCORE $SOUNDEX

Oracle Functions

CHR INSTR NEW_TIME NVL SUBSTR SYS_EXTRACT_UTC SYSDATE SYSTIMESTAMP TO_DATE TO_NUMBER

SETTINGS that affect SQL

SET SET SQL_SYNTAX=<ORACE|OMNIDEX|SQLSERVER> Allow Oracle and SqlServer extensions.
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.1278107112.txt.gz ยท Last modified: 2016/06/28 22:38 (external edit)
Sitemap Recent Changes