zOs/SQL/PDBGENY2

//A540769Z  JOB (CP00,KE50),                                            00010001
//         MSGCLASS=T,TIME=1440,
//         NOTIFY=A540769
//*MAIN CLASS=LOG0 SYSTEM=S12
//SELDD    EXEC PGM=IKJEFT01,DYNAMNBR=200,TIME=99                       00020001
//SYSTSIN  DD *
    DSN SYSTEM(DBOC)
   RUN PROGRAM(DSNTEP2) PARMS('ALIGN(LHS)') PLAN(DSNTEP2)
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTERM  DD DUMMY
//SYSIN    DD *
select  timestamp
      , plan_name
      , subsystem_id
      , OCCURRENCES
      , commit
      , class1_elapsed
      , class1_cpu_total
      , class1_su_cpu
      , class2_elapsed
      , class2_cpu_total
      , class2_su_cpu
      , group_name
      , CONNECT_TYPE
      , CONNECT_ID
      , CORRNAME
    from RZ2dd.TACCT_GENERAL g
    where plan_name in ('ER0044')
      and timestamp between '2012-12-21-00.00.00'
                        and '2012-12-21-23.59.59'
    order by subsystem_id
           , timestamp
//SELXX    EXEC PGM=IKJEFT01,DYNAMNBR=200,TIME=99                       00020001
//SYSTSIN  DD *
    DSN SYSTEM(DBOC)
   RUN PROGRAM(DSNTEP2) PARMS('ALIGN(LHS)') PLAN(DSNTEP2)
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTERM  DD DUMMY
//SYSIN    DD *
select  timestamp
      , plan_name
      , subsystem_id
      , OCCURRENCES
      , commit
      , class1_elapsed
      , class1_cpu_total
      , class1_su_cpu
      , class2_elapsed
      , class2_cpu_total
      , class2_su_cpu
      , group_name
      , CONNECT_TYPE
      , CONNECT_ID
      , CORRNAME
    from RZ2dd.TACCT_GENERAL g
    where plan_name in ('ER0044')
      and timestamp between '2012-12-21-00.00.00'
                        and '2012-12-21-23.59.59'
    order by subsystem_id
           , timestamp