zOs/SQL/ADBHOLD

select coalesce(c.userid, h.userid),                                    00001011
       coalesce(c.worklist, h.worklist),                                00001111
       c.COMITNUM coNu,c.COMMAND com, c.COMMAND_RESTART coRe,c.TIMESTMP,00002009
       count(*), h.stATUS, left(h.HOLDVAR, 10)                          00003012
    from adb.adbchkpt c                                                 00010004
    full outer join adb.adbhold h                                       00010104
    on c.userid = h.userid and c.worklist = h.worklist                  00010204
    group by c.userid, h.userid, c.worklist, h.worklist,                00010312
             c.COMITNUM, c.COMMAND, c.COMMAND_RESTART,c.TIMestmp,       00010412
             h.status, left(h.HOLDVAR, 10)                              00010512
    order by 1, 2, 8, 9                                                 00010612
;                                                                       00010704
SELECT count(*), c.timestmp, h.userid, h.worklist, h.suffix,            00010815
         h.stATUS, left(h.HOLDVAR, 10)                                  00010915
    FROM adb.adbhold h, adb.ADBCHKPT c                                  00011013
    where h.userid = c.userid and h.worklist = c.worklist               00011113
      and h.suffix = c.suffix                                           00011216
    group by c.timestmp, h.userid, h.worklist, h.suffix,                00011315
             h.stATUS, left(h.HOLDVAR, 10)                              00011415
    order by 7, 1 desc                                                  00011518
    ;                                                                   00011615
SELECT * FROM ADB.ADBCHKPT;                                             00011813
SELECT * FROM ADB.ADBHOLD                                               00012013
 -- WHERE WORKLIST = 'DB2BATCH'                                         00020002