Query full Informix database version using sql query

Question

What is the query required to get the full database version in an Informix database?

Answer 1

This is the simplest query that I could find.

SELECT DBINFO('version','full')
FROM systables
WHERE tabid = 1;

The result will be something like this:

IBM Informix Dynamic Server Version 11.70.FC5GE