Show pagesource
Old revisions

This is an old revision of the document!

DRAFT

Omnidex SQL Quick Reference

Omnidex SQL: Overview Statements Functions Examples Quick Ref
OdxSQL: Overview Commands Settings Command Line Quick Ref

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 Table
Special Export Partition Join Open Cursor Close Cursor
Other Install Indexes Remove Indexes Load OFX Command Extract *

* Statement is only available from OdxSQL.

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

Use the CREATE ENVIRONMENT SQL_SYNTAX setting or the SET SQL_SYNTAX setting to activate.

CHR INSTR NEW_TIME NVL SUBSTR SYS_EXTRACT_UTC SYSDATE SYSTIMESTAMP TO_DATE TO_NUMBER

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

 
Back to top
dev/sql/home.1278452054.txt.gz ยท Last modified: 2016/06/28 22:38 (external edit)
Sitemap Recent Changes