OMNIDEX Environment Catalog Syntax

ENVIRONMENT 

DATABASE

TABLE < tablename | "tablename" >

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
            

node GRID01
 database LIST filedsn "list01.dsn" local cache
  cluster
   table LIST partition by "STATE in ('MA','ME','NH','NY','PR','RI','VT') and 
                            ZIP between '00000' and '05999'"

node GRID02
 database LIST filedsn "list02.dsn" local cache
  cluster
   table LIST partition by "STATE in ('CT','NJ','NY') and 
                            ZIP between '06000' and '10999'"

node GRID03
 database LIST filedsn "list03.dsn" local cache
  cluster
   table LIST partition by "STATE in ('NY') and 
                            ZIP between '11000' and '14999'"

column “SUBTOTAL” datatype FLOAT length 8 as “AMOUNT * QUANTITY”

column “GRANDTOTAL” datatype FLOAT length 8 as “SUBTOTAL * TAX_RATE”

column “COMPANY_SDX” datatype C STRING length 40 as “$soundex(COMPANY)”

column “COUNTYSTATE” datatype CHARACTER length 5 as “COUNTY_CODE || STATE”

	where the “options” are:
	
		SPACE=proximity_spec
NEAR=proximity_spec
		BEFORE=proximity_spec
		PHRASE=proximity_spec
	
	and where “proximity_spec” is:

		NEAR(n) – means insure that word1 is within n words before or after word2.
		BEFORE(n) – means insure that word1 is within n words before word2
		PHRASE  - means insure that word1 immediately before word 2, and treat as a phrase rather than separate words.

The default behavior is as follows:

	SPACE=NEAR(999)
NEAR=NEAR(10)
	BEFORE=BEFORE(10)
	PHRASE=PHRASE 

One other change to the options in the clause is the removal of AUTOENABLE and NOAUTOENABLE. The AUTOENABLE option makes sense for things like SYNONYMS, but it doesn’t make sense for PROXIMITY since proximity is always in effect.

column "SUBTOTAL" datatype FLOAT length 8 as "AMOUNT * QUANTITY"

column "GRANDTOTAL" datatype FLOAT length 8 as "SUBTOTAL * TAX_RATE"

column "COMPANY_SDX" datatype C STRING length 40 as "$soundex(COMPANY)"

column "COUNTYSTATE" datatype CHARACTER length 5 as "COUNTY_CODE || STATE"