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
'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
14 January 2020