Ways to Obtain Status Information
The following functions enable an embedded SQL application program to obtain status information:
SESSION_PRIV
Returns session privilege information.
DBMSINFO
Returns information about the current session.
INQUIRE_SQL
Returns information about the last database statement that was executed.
SQLCA (SQL Communications Area)
Returns status and error information about the last SQL statement that was executed.
SQLCODE and SQLSTATE
Stand-alone variables in which the DBMS returns status information about the last SQL statement that was executed.