For Application Developers

Informix Application Development - Getting Started

IBM Informix Developer's Handbook

Embedding IBM Informix

Don't miss this

Videos

Understanding the Informix Version

In order to understand the Informix server version, you should look at the complete version of the product. You can get this by provided a -V to any of the Informix server binaries. (typically onstat -V). You should get something back like 11.70.UC1.

The first part of the version, upto the first period, is the major version number. In our example 11
The second part of the version, between the first and second periods, is the minor release number, 70 in our example.
The last part of the version is the most interesting and encodes many pieces of information.
The first position is a letter indicates the platform, some common platforms are listed below:

U

32 bit Unix

F

64 bit Unix or Windows

T

32 bit Windows

The second position is another letter indicates the type of product, generally only C for commercial.

The third position is a number indicating the maintenance release.

The letters starting at the the forth position can mean a few different things. The most common is the edition, followed by a special patch provided by IBM Informix support, a diagnostic build provided by IBM Informix support, or a combination of the items listed.

Lastly there is an SQL programming interface to retrieve the version and the different version components. You may use the SQL function called DBINFO(). The first argument is the string version followed by one of five options