Inquire_sql Statement
This statement provides runtime status information about the most recently executed SQL statement.
This statement has the following syntax:
inquire_sql(variablename = inquire_sql_constant
{, variablename = inquire_sql_constant});
The inquire_sql statement retrieves runtime status information about the most recently executed SQL statement. You can obtain the following information:
• Local and generic error numbers
• Error message text
• The text and number of a message statement in a database procedure
• The number of rows affected by the SQL statement
• Whether a transaction is open