Menu
What is the query required to get the full database version in an Informix database?
406
For the database engine, the easiest method to find the version is to use the command line: 'onstat -' (in the engine environment, while the engine is online). When you are seeking to identify the version for an Informix product other than Informix Dynamic Server, many Informix product commands have a '-V' option.
Key products. The current version of IBM Informix is 14.10.
For the edge and beyond. IBM® Informix® is an embeddable, high-performance database for integrating SQL, NoSQL, JSON, time-series and spatial data. Designed for analytics on the edge, in the cloud or on premises, the low-footprint database features self-management and automated administrative capabilities.
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With