Environment Catalog

Environment Statement

ENVIRONMENT environment_name
[VERSION "string"]
[TITLE "string"]
[SET
[WILDCARDS any_char, single_char, single_digit]
[OMNIDEX SENTINEL character]
[OPTIMIZATION "options"]
[ESCAPE character]
[SQL_SYNTAX {OMNIDEX | OMNIDEX_PLUS}]
[CENTURY_THRESHOLD n]
]

ENVIRONMENT environment_name

Environment name is a required string of up to 32 characters. Environment name can contain numbers and any of the allowed special characters. However, it MUST BEGIN WITH A LETTER, A-Z (case insensitive).

VERSION "string"

Optional. This is a string of up to 32 characters that defines a version number for the Environment file. VERSION is used for informational purposes only. It in no way affects the application or how Omnidex behaves against the environment.

TITLE "string"

Optional. This is a string of up to 80 characters that describes the Environment file. TITLE is used for informational purposes only. It in no way affects the application or how Omnidex behaves against the environment.

SET

Optional. The keyword SET is a section identifier for the SET section of the ENVIRONMENT definition. The following Environment settings are established through SET:

WILDCARDS

Must contain three different wildcard characters, separated by commas, from the following set: *!#%@^~{}'|?[]\/

Defaults

* (asterisk) any string

? (question mark) any character

# (pound sign) any ASCII digit

OMNIDEX SENTINEL character.

Default % (percent sign).

OPTIMIZATION

specifies the default type of optimization performed by Omnidex throughout an application connected to this environment. These options can be toggled on (optimization_setting) or off (NO_optimization_setting). Several optimization settings can be specified in a single SET command, separated by commas or spaces.
Example:

SET OPTIMIZATION="AGGREGATION, SERIAL"

ESCAPE character

Default \ (backslash). Only a single escape character can be defined.

SQL_SYNTAX {OMNIDEX | OMNIDEX_PLUS}

CENTURY THRESHOLD n

Specifies the year cutoff for determining the century in 2 digit years. For example, if the century threshold is set to 60, a 2 digit year of 45 would be translated to 2045 and a 2 digit year of 61 would be translated to 1961. This setting can be explicitly over-ridden for a specific column in the column definition.

Top