Previous Topic: -195 - IT IS INVALID TO SUBTRACT xx AND zz DATATYPESNext Topic: -199 - MONTH mm IS NOT BETWEEN 1 AND 12 INCLUSIVE


-198 - YEAR yy IS LARGER THAN 99

Explanation

A date has been found to contain an invalid year. yy represents the hexadecimal data type value. A valid value for the year is any integer greater than zero and less than 100. Either the date you supplied in the query is out of this range or the result of the calculation used to determine the value is out of this range. See the CA Datacom/DB SQL User Guide for DATE/TIME formats.

The SQLSTATE that equates to this SQL return code is 22008.

User Response

Correct the query to use a valid date or cause the calculation of a valid date.