There are three DBMSINFO constants available for use in queries involving IMA tables. DBMSINFO is a function that returns a string containing information about the current session.
This statement has the following syntax:
dbmsinfo('request_name')
where:
request_name refers to one of the following:
Returns the IMA MIB server vnode
Returns the IMA MIB server address
Returns the IMA MIB server session
For further information about using dbmsinfo, see the SQL Reference Guide.