RPG (IBM i / AS/400) · DB2 SQLCODE

SQLCODE -183 - Datetime Field Overflow

What does SQLCODE -183 - Datetime Field Overflow mean in RPG (IBM i / AS/400)?

An arithmetic operation on a DATE or TIMESTAMP value produced a result outside the range DB2 for i supports, such as an interval that pushes the date before the minimum or past the maximum supported value.

SQLCODE -183 - Datetime Field OverflowDB2 for i · SQLRPGLE

Condition

An arithmetic operation on a DATE or TIMESTAMP value produced a result outside the range DB2 for i supports, such as an interval that pushes the date before the minimum or past the maximum supported value.

Fix

Bound-check date arithmetic before executing it in SQL, especially when the interval or offset is calculated or comes from outside the program.

Related db2 sqlcode