SQLSTATE Messages

SQLSTATE codes return values that are error, warning, or “no data found” messages. Here’s how SQLSTATE and SQLCODE messages correspond to each other.

If a WHENEVER SQLERROR CALL myproc() statement is in effect, myproc() is called when SQLSTATE returns a value with a nonzero first digit.

Use SQLSTATE to check for exceptions and warnings. To use SQLSTATE in a program, you must explicitly declare SQLSTATE within a host variable declaration block, for example:

EXEC SQL BEGIN DECLARE SECTION ;

char SQLSTATE [6] ;  // 5 characters for code and one character for

                     // null terminator

EXEC SQL END DECLARE SECTION;

Errors caught at compile time by using the /SQLACCESS option will not be mapped to SQLSTATE values at run time.

Microsoft® SQL Server™ errors map to these SQLSTATE codes.