Administrative and Operational Enhancements › Century Validation › SYSIDMS Parameters

SYSIDMS Parameters

The following new SYSIDMS parameters provide enhanced control over date processing in local mode:

EVAL_BASE_YEAR=base-year

Specifies the base year to be assumed by the DATEDIFF and DATEOFF built-in functions. The base year is used to determine whether a two-digit year is considered to be in the twentieth or twenty-first centuries. A year whose value is greater than the base year is considered to be in the twentieth century; values less than or equal to the base year are considered to be in the twenty-first century.

Limits: 1 - 99

Default: 68

EVAL_CENTURY_VALIDATION=ON|OFF

Specifies whether century values are to be validated by built-in functions that accept four-digit years such as GOODDATEX.

ON

Validate century values.

OFF

Does not validate century values.

Default: OFF

EVAL_LOW_CENTURY=low-century

Specifies the lowest century value to be considered valid. The value specified is used during century validation in built-in functions that accept four-digit years such as GOODDATEX. Centuries are validated only if the EVAL CENTURY VALIDATION is ON.

Limits: 1 - 99

Default: 19

EVAL_HIGH_CENTURY=high-century

Specifies the highest century value to be considered valid. The value specified is used during century validation in built-in functions that accept 4-digit years such as GOODDATEX. Centuries are validated only if the EVAL CENTURY VALIDATION is ON.

Limits: 1 - 99

Default: 20