zOs/SQL/WIREF
---------+---------+---------+---------+---------+---------+---------+---------+
select char(', ''' || strip(pk.NAME) || '''', 12) pkg
, max(pcTimestamp) pc
from sysIbm.sysPackage pk
where (pk.location, pk.collid, pk.name, pk.conToken) in
(select pkd.dLocation, pkd.dCollid, pkd.dName, pkd.dConToken
from sysIbm.sysPackDep pkd
where (pkd.bQualifier, pkd.bName) in
(select t.creator, t.name
from sysIbm.sysTables t
where t.type not in ('A', 'V') and t.name like 'TWI105A1%'
) )
group by pk.name
order by pk.name
---------+---------+---------+---------+---------+---------+---------+---------+
PKG PC
---------+---------+---------+---------+---------+---------+---------+---------+
, 'TN7004' 2013-10-01-06.45.53.205748
, 'TN8400' 2013-09-26-07.17.48.883049
, 'TN8900' 2008-01-22-14.42.32.516517
, 'YTN0100' 2008-06-23-13.39.03.567857
, 'YTN0101' 2013-09-26-07.07.44.727819
, 'YTN0102' 2013-09-26-07.08.15.373505
, 'YTN0103' 2013-09-26-07.08.07.056183
, 'YTN0104' 2013-09-26-07.08.18.602603
, 'YTN0105' 2013-09-26-07.08.10.210846
, 'YTN0106' 2013-12-06-06.46.11.298867
, 'YTN0107' 2013-12-19-13.46.52.270132
, 'YTN0151' 2013-01-15-08.05.03.451624
, 'YTN0152' 2013-03-25-17.57.36.640052
, 'YTN0161' 2013-03-25-18.05.41.638020
, 'YTN0200' 2013-01-15-08.05.29.827066
, 'YTN0201' 2008-03-17-12.31.47.067944
, 'YTN0202' 2008-07-22-11.13.29.807033
, 'YTN0203' 2013-09-26-07.08.49.105241
, 'YTN0204' 2014-01-28-14.23.47.432983
, 'YTN0205' 2013-09-26-07.08.52.707003
, 'YTN0210' 2012-09-12-07.25.35.996865
, 'YTNI105' 2013-12-06-06.45.39.748117
, 'YWI1320' 2013-12-04-10.56.25.595550
, 'YWI1330' 2014-02-04-11.21.45.221045
, 'YWI1340' 2013-12-04-10.58.04.195175
, 'YWI1350' 2013-12-04-10.58.18.501420
, 'YWI1371' 2012-06-22-17.07.56.309193
, 'YWI1521' 2012-06-22-17.08.03.711674
, 'YWI5951' 2012-06-22-17.09.28.482956
, 'YWI5952' 2012-06-22-17.09.28.217891
, 'YWI5953' 2012-06-22-17.09.28.399771
, 'YWI5954' 2012-06-22-17.09.28.227130
, 'YWI5955' 2012-06-22-17.09.27.898364
, 'YWI5956' 2012-06-22-17.09.34.680568
, 'YWI5957' 2012-06-22-17.09.37.412187
, 'YWI5958' 2012-06-22-17.09.40.572168
, 'YWI5959' 2012-06-22-17.09.43.671237
, 'YWI595A' 2012-06-22-17.09.27.606247
, 'YWIABV' 2013-10-15-13.10.15.814885
, 'YWIABV2' 2010-09-16-13.00.38.978871
, 'YWIABV3' 2013-10-15-13.13.04.562075
, 'YWIACW1' 2012-06-22-15.59.14.877652
, 'YWIADS' 2013-09-18-10.18.29.361154
PKG PC
---------+---------+---------+---------+---------+---------+---------+---------+
, 'YWIANPE' 2009-01-08-10.59.57.207463
, 'YWIANPF' 2013-05-16-15.22.21.847066
, 'YWIANPL' 2012-06-22-15.59.22.021761
, 'YWIAOT2' 2012-06-22-15.59.24.543019
, 'YWIAOT3' 2013-09-18-10.18.34.524764
, 'YWIAOTX' 2012-06-26-11.57.25.409866
, 'YWIAWD' 2012-06-22-15.59.28.007732
, 'YWIBINF' 2012-06-22-16.00.09.361935
, 'YWIESOQ' 2013-09-19-07.35.41.233251
, 'YWILODA' 2013-12-04-10.40.43.486707
, 'YWINE01' 2011-12-07-07.03.36.102890
, 'YWINE09' 2011-12-07-07.03.38.078335
, 'YWINS01' 2014-02-07-12.51.10.788424
, 'YWINS02' 2014-02-07-12.57.47.102269
, 'YWINS03' 2014-02-07-12.57.53.295006
, 'YWINS04' 2014-02-07-12.58.00.211738
, 'YWINS05' 2014-02-07-12.58.06.628978
, 'YWINS06' 2014-02-07-12.58.14.021716
, 'YWINS07' 2014-02-07-12.58.22.822249
, 'YWINS08' 2014-02-07-12.58.31.348292
, 'YWINS09' 2014-02-07-12.58.37.230219
, 'YWINS10' 2014-02-07-12.58.52.388914
, 'YWINS90' 2013-12-04-10.45.58.226704
, 'YWINS91' 2013-12-04-10.46.10.735496
, 'YWINS92' 2013-12-04-10.46.11.176799
, 'YWINS93' 2013-12-04-10.46.18.495313
, 'YWINS94' 2013-12-04-10.46.27.801874
, 'YWINS95' 2013-12-04-10.46.29.737053
, 'YWINS96' 2013-12-04-10.46.42.884923
, 'YWINS97' 2013-12-04-10.46.41.791333
, 'YWINS98' 2013-12-04-10.46.42.531875
, 'YWINS99' 2013-12-04-10.47.59.543038
, 'YWIRS01' 2012-06-22-16.56.27.766283
, 'YWIRS02' 2012-06-22-16.56.27.646885
, 'YWIRS03' 2012-06-22-16.56.29.643729
, 'YWIRS04' 2012-06-22-16.56.29.817869
, 'YWIRS05' 2012-06-22-16.56.32.112196
, 'YWIRS06' 2012-06-22-16.56.34.364608
, 'YWIRS07' 2012-06-22-16.56.35.953789
, 'YWIRS08' 2012-06-22-16.56.37.933933
, 'YWIRS09' 2012-06-22-16.56.45.532252
, 'YWIRS10' 2012-06-22-16.56.48.508399
, 'YWISEMQ' 2013-09-19-13.51.37.342210
, 'YWISLWS' 2013-09-18-10.24.31.869565
, 'YXWICFI' 2010-09-16-13.03.39.934087
, 'YXWISIN' 2010-10-29-13.32.16.739916
, 'YYWIVER' 2014-01-21-12.06.11.990069
DSNE610I NUMBER OF ROWS DISPLAYED IS 90
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100
---------+---------+---------+---------+---------+---------+---------+---------+
DSNE617I COMMIT PERFORMED, SQLCODE IS 0
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
---------+---------+---------+---------+---------+---------+---------+---------+
DSNE601I SQL STATEMENTS ASSUMED TO BE BETWEEN COLUMNS 1 AND 72
DSNE620I NUMBER OF SQL STATEMENTS PROCESSED IS 1
DSNE621I NUMBER OF INPUT RECORDS READ IS 13
DSNE622I NUMBER OF OUTPUT RECORDS WRITTEN IS 119