Enhance QSYS2.PARTITION_STATISTICS function to include the member text when source file members are queried.

Please enhance QSYS2.PARTITION_STATISTICS to include the member text when source file members are queried.

Currently, this function returns the member name, the source type (i.e., RPGLE, PF, CLLE, etc.), the last source update timestamp, the source creation timestamp, and the "last source type and/or member text changed" timestamp. With the exception of the line that has "b.SOURCE_MEMBER_TEXT" in it, the following works on V7R* systems with appropriate TR levels.

SELECT A.DBXLIB as SRCPF_LIBR
, A.DBXFIL as SRCPF_NAME
, B.SYSTEM_TABLE_MEMBER as SrcMbrName
, B.LAST_SOURCE_UPDATE_TIMESTAMP as SRCPF_UDAT
, B.SOURCE_TYPE as SRCPF_SRCTYPE
, b.CREATE_TIMESTAMP as Source_Create_Timestamp
, b.LAST_CHANGE_TIMESTAMP as Source_Type_Text_Change_Timestamp
, b.SOURCE_MEMBER_TEXT
FROM QSYS.QADBXATR A
, LATERAL
( SELECT * FROM TABLE
( QSYS2.PARTITION_STATISTICS(A.DBXLIB, A.DBXFIL)
) AS X
) AS B
WHERE A.DBXATR = 'PF'
and A.DBXREL = 'Y'
and A.DBXTYP = 'S'
AND B.SOURCE_TYPE IS NOT NULL

Given what the existing function provides, including the source member text column is a very natural extension to it.

The goal of the SQL example above is to provide a quick method of identifying a given source member name anywhere on the system, regardless of the library. Part of identifying members properly is to have the member text associated with the source member name. This solution is intended to be used as part of an existing utility which currently relies on much more time-consuming methods, making it essentially useless for its intended function. The business justification for this is to allow developers to use a tool to *quickly* identify source members on the system, saving them time compared to the currently available methods to do something similar.