Db2 11.1

Messages handling roadmap

Messages are used to convey event information to you. You can incorporate message handling in your application to process various events that can arise during database tasks. Events can include errors, warning, and informational messages.

Table 1 lists information for handling messages in various types of applications:

Table 1. Roadmap for handling Db2 messages
Application type	Related information
Admin API applications	sqlogstt API - Get the SQLSTATE message
CLI applications	SQLSTATES for CLI Return codes and SQLSTATES for CLI
Db2® .NET applications	DB2Error.SQLState property
Embedded SQL applications	Declaring the SQLCA for error handling Error information in the SQLCODE, SQLSTATE, and SQLWARN fields Including SQLSTATE and SQLCODE host variables in embedded SQL applications SQLSTATES and SQLCODE variables in COBOL embedded SQL applications SQLSTATE and SQLCODE variables in FORTRAN embedded SQL applications SQLSTATE and SQLCODE variables in C and C++ embedded SQL applications
JDBC and SQLJ applications	Handling SQL errors in an SQLJ application Handling SQL warnings in an SQLJ applications SQLSTATEs issued by the IBM® Data Server Driver for JDBC and SQLJ Handling an SQLException under the IBM Data Server Driver for JDBC and SQLJ
Perl applications	SQLSTATE and SQLCODE variables in Perl
PHP applications	Error-handling functions in PHP applications (ibm_db2) Handling errors and warnings in PHP (PDO)
Python applications	Error-handling functions in Python
SQL procedures	SQLCODE and SQLSTATE variables in SQL procedures
User exit programs	User exit error handling