EARLIEST_POSSIBLE_RELEASE

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