Example documentationVERSION Locate this document in the navigation structure

 

Use of the system table SYSINFO.VERSION

Prerequisites

You can use the DEMODB demo database. Start the Database Studio and log onto the demo database DEMODB: Logging On to a Database.

Activities

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