Error Handling and Problem Determination

DB2 ODBC functions return their status as an integer return code, indicated by the SQLRETURN data type. This return code can have several values, documented in Table 11-1.

Table 11-1. Status Return Codes of DB2 ODBC Functions
RETURN CODE EXPLANATION
SQL_SUCCESS The function completed successfully; no additional SQLSTATE information is available.
SQL_SUCCESS_WITH_INFO The function completed successfully with a warning or other information. Call SQLGetDiagRec() to receive the SQLSTATE and any other informational messages or warnings.
SQL_NO_DATA_FOUND The function returned successfully, but no relevant data was found. When this is returned after the execution of an SQL statement, additional information might ...

Get DB2® Universal Database™ for OS/390™ v7.1 Application Certification Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.