3. Elements of SQL Statements : SQL Functions : DBMSINFO Function : 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');