This is an old revision of the document!
* Statement is only available from OdxSQL.
SET | SET SQL_SYNTAX=<ORACE|OMNIDEX|SQLSERVER> | Allow Oracle functions and SqlServer bracket syntax. |
OdxSQL | SET TERMINATION [ ON | OFF ] | Set auto termination of statements. |
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>
$omnidex | special table of one row and one column. Good to test functions, etc. |
$uniquekey | |
$ROWID |