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

SQLCODE -402

Arithmetic overflow in function

Explanation

Result of an arithmetic function exceeds data type limits.

Solution

Check input values, use appropriate precision, handle edge cases.

Example

SELECT SUM(LARGE_NUMBER) that exceeds DECIMAL limits