Re: Member Text of source member not in SYSPSTAT; where to find?

I was hoping that this would be an excuse to dig into the UDTF that
Birgitta wrote for
https://www.ibm.com/developerworks/ibmi/library/i-power-of-udtf/ but I
couldn't get it to join and return info for each row. I dug out another
little chunk of code from a utility service program, wrapped it as a UDF
and this works.

http://code.midrange.com/5eef431128.html Create the module/service
program/UDF and then just change your sql to:

SELECT A.DBXLIB as SRCPF_LIBR
, A.DBXFIL as SRCPF_NAME
, B.SYSTEM_TABLE_MEMBER as SrcMbrName

, UDFRTVMBRD(A.DBXLIB,A.DBXFIL,B.SYSTEM_TABLE_MEMBER) as SrcMbrDesc

, 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
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

Kevin Bucknum
Senior Programmer Analyst