SQL Reference Guide > SQL Reference Guide > SQL Statements > SELECT (embedded) > Error Handling for Embedded SELECT
Was this helpful?
Error Handling for Embedded SELECT
If the SELECT statement retrieves no rows, the SQLCA variable sqlcode is set to 100. The number of rows returned from the database is in the SQLCA variable sqlerrd(3). In a select loop, if the ENDSELECT statement was issued, sqlerrd(3) contains the number of rows retrieved before ENDSELECT was issued.
Last modified date: 01/30/2023