Dbmsinfo Examples
To see the version of Ingres 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');