COBOL · DB2 SQLCODE

SQLCODE -180

What does SQLCODE -180 mean in COBOL?

Invalid date or time format. A date, time, or timestamp string does not match the format DB2 expects, or contains an internally invalid value, such as a month greater than 12 or a day greater than 31.

SQLCODE -180DB2 for z/OS · Db2 (embedded SQL in COBOL)

Condition

Invalid date or time format. A date, time, or timestamp string does not match the format DB2 expects, or contains an internally invalid value, such as a month greater than 12 or a day greater than 31.

Fix

Check the exact string being passed against the format DB2 expects for that column (commonly ISO or MM/DD/YYYY depending on configuration), and validate the value's actual range before sending it.

Pending source verification. Not yet checked against official documentation.

Related db2 sqlcode