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.