zOs/SQL/SYSCOPY

SELECT JOBNAME, ICTYPE, COUNT(*), MAX(TIMESTAMP)                        00010005
    FROM SYSIBM.SYSCOPY C                                               00011005
    WHERE DBNAME = 'TSTNAKBJ'                                           00012005
    GROUP BY JOBNAME, ICTYPE                                            00012105
    ORDER BY 1, 2                                                       00012206
;                                                                       00012305
X                                                                       00012405
SELECT DBNAME, TSNAME, ICTYPE, TIMESTAMP, JOBNAME                       00013000
    FROM SYSIBM.SYSCOPY C                                               00014000
    WHERE C.ICTYPE IN ('B', 'W', 'X')                                   00015000
          AND JOBNAME NOT LIKE 'QR%'                                    00016001
    ORDER BY JOBNAME                                                    00017003
--  ORDER BY TIMESTAMP                                                  00018004