6. Working with Transactions and Handling Errors : Ways to Obtain Status Information : DBMSINFO Function--Return Information About the Current Session
 
Share this page                  
DBMSINFO Function--Return Information About the Current Session
DBMSINFO is a SQL function that returns a string containing information about the current session. Use this function in a terminal monitor or in an embedded SQL application.
The DBMSINFO function is used in a SELECT statement as follows:
SELECT DBMSINFO('request_name')
where 'request_name' is one of those described in Request Names for DBMSINFO Function (see Request Names for DBMSINFO Function).