10. Understanding Ingres Management Architecture : IMA DBMSINFO Constants
 
Share this page                  
IMA DBMSINFO Constants
The DBMSINFO function returns a string containing information about the current session. Three DBMSINFO constants are for use in queries involving IMA tables.
This statement has the following syntax:
DBMSINFO('request_name')
where:
request_name refers to one of the following:
ima_vnode
Returns the IMA MIB server vnode
ima_server
Returns the IMA MIB server address
ima_session
Returns the IMA MIB server session ID
For more information about using DBMSINFO, see the SQL Reference Guide.