Select r.ROUTINESCHEMA, r.ROUTINENAME,r.routinetype,r.specificname,D.BName ,D.BType,pgd.bname
from syscat.routineDEP D,SYSCAT.ROUTINES R, syscat.PACKAGEDEP pgd
where d.SPECIFICNAME = R.specificname and ROUTINETYPE = 'P'
and d.BNAME = pgd.PKGNAME and pgd.BTYPE = 'T'
fetch first 20000 rows only
can anybody tell me if I GOT it