SQL Reference Guide > SQL Reference Guide > Working with Transactions and Handling Errors > Ways to Obtain Status Information > INQUIRE_SQL Function
Was this helpful?
INQUIRE_SQL Function
The INQUIRE_SQL function returns information about the status of the last SQL database statement issued by an application.
The INQUIRE_SQL function can provide the following information on the occurrence of an error:
• Return the error number and the complete error text.
• Retrieve the message number and text from a message statement that was executed inside a database procedure.
• Determine if your session is returning local or generic errors, if a transaction is open, or what session is currently active (useful in multiple-session applications).
The INQUIRE_SQL function does not return status information about forms statements. To obtain information about the results of forms statements, use the INQUIRE_FRS statement.
For a complete list and description of available status information, see INQUIRE_SQL on page 704.
Last modified date: 04/03/2024