This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
oaenv:overview [2009/11/30 18:15] 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 | ||
| - | ===== DATABASE ===== | ||
| - | |||
| - | DATABASE | ||
| - | ===== TABLE ===== | ||
| - | |||
| - | TABLE < tablename | "tablename" > | ||
| - | ===== TABLE COLUMN ===== | ||
| - | |||
| - | 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)" > ] | ||
| - | |||
| - | 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" | ||
| - | |||
| - | <code> | ||
| - | 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 | ||
| - | </code> | ||
| - | 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. | ||
| - | ==== EXAMPLES ==== | ||
| - | 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" | ||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||