This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
oaenv:overview [2009/12/01 04:46] tdo |
— (current) | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
| - | ====== OMNIDEX Environment Catalog Syntax ====== | ||
| - | ===== ENVIRONMENT ===== | ||
| - | ENVIRONMENT < environment_name > | ||
| - | ===== DATABASE ===== | ||
| - | DATABASE < database_name > | ||
| - | TYPE < flatfile | | ||
| - | ===== TABLE ===== | ||
| - | TABLE < tablename | "tablename" > | ||
| - | [ TYPE < ROLLUP | > ] | ||
| - | [ PHYSICAL "filespec" ] | ||
| - | [ AS "select_statment" ] | ||
| - | [ PRIMARY KEY “col1”,”col2” ] | ||
| - | [ FOREIGN KEY “col1”,”col2” REFERENCES “table1”(“col1”,”col2”) ] | ||
| - | < COLUMN column_spec [ COLUMN column_spec ... > ] | ||
| - | |||
| - | ===== Column Specification ===== | ||
| - | COLUMN column-name DATATYPE datatype-spec | ||
| - | [PROXIMITY “options”] | ||
| - | [SYNONYMS 'options'] | ||
| - | [SPELLCHECK 'options'] | ||
| - | [MISSPELLINGS 'options'] | ||
| - | [FORMS 'options'] | ||
| - | [STOPWORDS 'options'] | ||
| - | [PHONETIC 'options'] | ||
| - | [INCLUDED_TAGS 'options'] | ||
| - | [EXCLUDED_TAGS 'options'] | ||
| - | {AS < columnspec | "$retrieve_file(FILENAME)" > ] | ||
| - | |||
| - | ===== INDEX ===== | ||
| - | |||
| - | ===== NODE ===== | ||
| - | NODE nodename | ||
| - | DATABASE dbname FILEDSN "dsn" | ||
| - | [ LOCAL ] | ||
| - | [ CACHE ] | ||
| - | CLUSTER table | ||
| - | [PARTITION BY criteria_expression | ||
| - | |||
| - | ===== Examples ===== | ||
| - | ==== Step 1 - Creating the Omnidex Environment Source ==== | ||
| - | |||
| - | The following sample Environment Catalog Source is the minimum set of statements that will compile into an Omnidex Compiled Environment. | ||
| - | |||
| - | <code> | ||
| - | ENVIRONMENT tinyenv | ||
| - | DATABASE tinydb | ||
| - | TYPE flatfile | ||
| - | TABLE table1 | ||
| - | COLUMN C1 DATATYPE INTEGER | ||
| - | </code> | ||
| - | |||
| - | This creates an Omnidex Environment named "tinyenv" with a single Database named "tinydb" with one table named "table1". Because the DATABASE TYPE is "flatfile", the name of the underlying operating system file for this table is "table1". Typically a filespec location would be used. Copy and save this environment as "tiny.src". | ||
| - | |||
| - | ==== Step 2 - Compiling the Omnidex Environment ==== | ||
| - | |||
| - | os> oacomp tiny.src tiny.env | ||
| - | ==== Step 3 - Use OdxSQL to test, verify and manipulate the Environment ==== | ||
| - | |||
| - | os> odxsql tiny.env | ||
| - | |||
| - | or | ||
| - | |||
| - | os> odxsql | ||
| - | > connect tiny.env | ||
| - | |||
| - | > create file table1 | ||
| - | |||
| - | > insert into table1 values (1) | ||
| - | |||
| - | > select * from table1 | ||
| - | |||
| - | <code> | ||
| - | |||
| - | C:\dev\odx\tiny>more tiny.src | ||
| - | ENVIRONMENT tinyenv | ||
| - | DATABASE tinydb | ||
| - | TYPE flatfile | ||
| - | TABLE table1 | ||
| - | COLUMN C1 DATATYPE INTEGER | ||
| - | |||
| - | |||
| - | C:\dev\odx\tiny>oacomp tiny.src tiny.env | ||
| - | OACOMP - Omnidex Environment Compiler Mon Nov 30 21:41:50 2009 | ||
| - | (c) Dynamic Information Systems Corp. 1981-2009 5.0 Build 1H | ||
| - | Microsoft Windows XP Professional SP 3 (2600) TDO830/TDO | ||
| - | ** Trial Copy ** | ||
| - | |||
| - | Parsed; Validated; Compiled; Done | ||
| - | ** Environment Compiled Successfully! ** | ||
| - | |||
| - | |||
| - | C:\dev\odx\tiny>odxsql tiny.env | ||
| - | ODXSQL - Omnidex SQL Mon Nov 30 21:41:59 2009 | ||
| - | (c) Dynamic Information Systems Corp. 1981-2009 5.0 Build 1H | ||
| - | Microsoft Windows XP Professional SP 3 (2600) TDO830/TDO | ||
| - | ** Trial Copy ** | ||
| - | |||
| - | |||
| - | Connected to C:\dev\odx\tiny\tiny.env | ||
| - | > create file table1 | ||
| - | File table1 created | ||
| - | > insert into table1 values (1) | ||
| - | 1 row inserted into TABLE1 | ||
| - | > select * from table1 | ||
| - | |||
| - | C1 | ||
| - | ----------- | ||
| - | 1 | ||
| - | |||
| - | 1 row returned | ||
| - | > | ||
| - | </code> | ||
| - | |||
| - | ==== Step 4 - Install and Build Indexes with DBINSTAL ==== | ||
| - | |||
| - | ==== Step 5 - Develop an Application with ODBC, JDBC or Stored Procedures ==== | ||
| - | |||
| - | After creating an Omnidex Environment | ||
| - | |||
| - | | ||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||