System Administrator Guide > System Administrator Guide > Understanding Ingres Management Architecture > IMA DBMSINFO Constants
Was this helpful?
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.
Last modified date: 01/30/2023