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