zOs/SQL/BINDXSEM

$#@
$**                 neueste Packages
call sqlConnect dbof
$;
$>~wk.texv(bindXsel)
$<=[
with n as
(
  select p.*
      , row_number() over (partition by collid, name
                           order by pcTimestamp desc) rv
    from sysibm.sysPackage p
    where length(strip(collid)) <= 4
    order by pcTimestamp desc
    fetch first 1000 rows only
)
select name pgm, collid col, pcTimestamp, version
     , OWNER
     , QUALIFIER
     , ISOLATION
     , RELEASE
     , EXPLAIN
     , DEGREE
     , DYNAMICRULES
     , KEEPDYNAMIC
     , REOPTVAR
     , case when OPTHINT='' then '-' else optHint end optHint
     , IMMEDWRITE
     , case when PATHSCHEMAS='' then '-' else pathSchemas end
                                                  pathSchemas
     , VALIDATE
     , SQLERROR
     , DEFERPREP
     , DEFERPREPARE
    from n
    where rv = 1
    order by pgm, col
    with ur
$]
call sqlSel
$| call fmtFTab
$#out                                              20131115 13:37:37
*** run error ***
SQLCODE = -924: DB2 CONNECTION INTERNAL ERROR, 00000002,
    0000000C, 00F30006
sql = connect DBOF
$#out                                              20131111 21:07:08