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 on page 152.
Dbmsinfo Examples
To see the version of Vector runtime you are using, enter:
SELECT DBMSINFO('_VERSION');
The DBMSINFO function can be used in WHERE clauses in SELECT statements. For example:
EXEC SQL SELECT dept FROM employee
WHERE ename=DBMSINFO('USERNAME');
Last modified date: 03/21/2024