SQL Language Guide : 7. SQL Statements : SELECT (Embedded) : Error Handling for Embedded SELECT
 
Share this page                  
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.