Diagnostics in a DB2 UDB CLI application

 

There are two levels of diagnostics for DB2^® UDB call level interface (CLI) functions.

• Return codes from a DB2 UDB CLI application

• DB2 UDB CLI SQLSTATEs (diagnostic messages)

• Return codes from a DB2 UDB CLI application
  Possible return codes for DB2 UDB call level interface (CLI) functions include SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_NO_DATA_FOUND, SQL_ERROR, and SQL_INVALID_HANDLE.

• DB2 UDB CLI SQLSTATE values
  Because different database servers often have different diagnostic message codes, DB2 UDB call level interface (CLI) provides a standard set of SQLSTATE values that are defined by the X/Open SQL CAE specification. This allows consistent message handling across different database servers.

 

Parent topic:

Writing a DB2 UDB CLI application