6. Working with Transactions and Handling Errors : Ways to Obtain Status Information : DBMSINFO Function--Return Information About the Current Session : Dbmsinfo Examples
 
Share this page                  
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');