Master Mainframe Technologies - COBOL, JCL, DB2, VSAM, CICS & More
ABEND Codes SQLCODEs File Status Interview Prep Contact
← Back to SQLCODE Reference
Error

SQLCODE -180

Invalid date/time/timestamp

Explanation

The string representation of a date, time, or timestamp is invalid.

Solution

Check date format (YYYY-MM-DD), time format (HH.MM.SS), timestamp format. Verify valid values.

Example

WHERE DATE_COL = "2024-13-45" -- Invalid month/day