IBM Support

EARLIEST_POSSIBLE_RELEASE

News


Abstract

EARLIEST_POSSIBLE_RELEASE

Content


We support a way to see the earliest possible IBM i release which could be used for any SQL statement or program.

The SQL statement level detail is available via Database Monitor.
The program level detail is available via the QSYS2/SYSPROGRAMSTAT and QSYS2/SYSPACKAGESTAT catalogs.

Database Monitor and the QSYS2/SYSPROGRAMSTAT & SYSPACKAGESTAT catalogs can be used to evaluate SQL application deployment possibilities per operating system releases.

The QQC82 column contains the earliest IBM i OS release level where this SQL statement is supported. This information can be used to assess whether applications are capable of being deployed on earlier IBM i releases or whether they are using SQL functionality unique to IBM i 6.1 or later.

This field only applies if the SQL statement is dynamic. (QQC12= 'D')

Possible values for QQC82:
' ' - The statement release level has not been determined
'ANY' - The statement is valid on any supported IBM i OS
release
'VvRrMm' - The statement is valid on this specific IBM i release or later

QSYS2/SYSPROGRAMSTAT and SYSPACKAGESTAT column name EARLIEST_POSSIBLE_RELEASE.

System column name: MINRLS

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}}]

Document Information

Modified date:
14 January 2020

UID

ibm11167748