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

SQLCODE 100

No data found / End of data

Explanation

For SELECT INTO: no row satisfied the search condition. For FETCH: no more rows in result set. For UPDATE/DELETE: no rows matched WHERE clause.

Solution

Check if this is expected. For cursors, use as loop termination condition. For SELECT INTO, handle the "not found" case.

Example

EXEC SQL FETCH cursor INTO :var END-EXEC. IF SQLCODE = 100 GO TO END-CURSOR.