OMNIDEX Environment Catalog Syntax

ENVIRONMENT < environment_name >

DATABASE < database_name >
    TYPE < flatfile | 

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 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)" > ]

    NODE nodename
        DATABASE dbname FILEDSN "dsn" 
            [ LOCAL ]
            [ CACHE ]
        CLUSTER table
            [PARTITION BY criteria_expression

The following sample Environment Catalog Source is the minimum set of statements that will compile into an Omnidex Compiled Environment.

ENVIRONMENT tinyenv
DATABASE tinydb
  TYPE flatfile
TABLE table1
  COLUMN C1 DATATYPE INTEGER

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”.

os> oacomp tiny.src tiny.env

os> odxsql tiny.env

or

os> odxsql
> connect tiny.env

> create file table1

> insert into table1 values (1)

> select * from table1

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
>

After creating an Omnidex Environment and adding Omnidex indexes via DBINSTAL, applications can be developed using the DISC provided ODBC and JDBC drivers.

==== Step 6 - Simulate a client server environment using OdxNet with ODBC or JDBC