This SELECT statement retrieves the version and release of the current Advanced SQL Engine software.
SELECT infokey (format ‘x(30)’), infodata (format ‘x(20)’) FROM DBC.DBCInfoV ORDER BY infokey;
Result:
InfoKey InfoData --------------------- -------------------- LANGUAGE SUPPORT MODE Japanese RELEASE 14.10j.00.00 VERSION 14.10j.00.00
For the language support mode, InfoData is either Standard or Japanese.
The values for Version and Release are broken down into 4 parts:
- Major release
- Minor release
- Maintenance release
- E-fix release
For example, 14.10.02.03 represents the following:
Value | Description |
---|---|
14 | Major release number |
10 | Minor release number |
02 | Maintenance release number |
03 | E-fix or patch release number |