Use of the system table SYSINFO.VERSION
You can use the DEMODB demo database. Start the Database Studio and log onto the demo database DEMODB an: Logging On to a Database.
You can use Database Studio to enter and execute SQL statements. More information: Working with SQL Statements: Overview
Note the General Instructions for formulating SQL statements.
You can use the system table VERSION to determine the following database information, among other things:
Version of the software used by the currently active database
SELECT majorversion, minorversion, correctionlevel, build
FROM SYSINFO.VERSION
Version of the operating system
SELECT operatingsystem
FROM SYSINFO.VERSION
Kernel variant
SELECT KERNELVARIANT
FROM SYSINFO.VERSION