zOs/SQL/CATPLAN

$#@
$=dbSy=dbtf
call sqlConnect $dbSy
call sqlSel "select p.NAME, l.SEQNO, l.LOCATION, l.COLLID, l.NAME",
     "from sysibm.sysPlan p",
     "left join sysibm.sysPackList l",
     "on l.planName = p.name",
     "where p.name like 'M%'",
     "order by 1, 2"
$|
$$- $dbSy date('s')
call fmtFTab
$#out                                              20120828 17:13:03
dbtf 20120828
NAME     NO LOCATION         COLLID                   COL5