Query full Informix database version using sql query

Question

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

h-rai · Accepted Answer · 2017-04-20 23:12:27Z

17

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

answered Apr 20, 2017 at 23:12

h-rai

4,0548 gold badges56 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jonathan Leffler Over a year ago

As documented in the Informix Knowledge Center under DBINFO — using the version option there are also other arguments that can be supplied in place of 'full' to get different results.

Farid Z Over a year ago

I needed to qualify with schema name: SELECT DBINFO('version','full') FROM informix.systables WHERE tabid = 1

Collectives™ on Stack Overflow

Query full Informix database version using sql query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related