Show TOC

Example documentationVERSION

 

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