SeanHoppe.com Cleo Code Samples CLEO CLP: PRTACKTP & PRTCNNSEL
/*****************************************************************************/ /* CL runs the following CLEO reports: PRTACKTP and PRTCNNSEL. */ /* CL runs custom queries: -- Queries are located in LIB:XXXXXX */ /* EXT_ENVERR */ /* EXT_GENERR */ /* EXT_TRNERR */ /* EXT_UNWERR */ /* EXT_WRPERR */ /* */ /* To add a new EXTOL generated report use the following date variables */ /* Start Date: &WDATE / End Date (today): &TDATE */ /* To add a new customer query report use the following date variables */ /* Start Date: &STARTDATE / End Date (today): &ENDDATE */ /* */ /*****************************************************************************/ PGM DCL VAR(&JOB) TYPE(*CHAR) LEN(10) DCL VAR(&USER) TYPE(*CHAR) LEN(10) DCL VAR(&NBR) TYPE(*CHAR) LEN(6) DCL VAR(&SYSDATE) TYPE(*CHAR) LEN(6) DCL VAR(&YESTERDAY) TYPE(*DEC) LEN(8 0) DCL VAR(&LILIAN) TYPE(*CHAR) LEN(4) DCL VAR(&JUNK1) TYPE(*CHAR) LEN(8) DCL VAR(&JUNK2) TYPE(*CHAR) LEN(23) DCL VAR(&WDATE) TYPE(*CHAR) LEN(8) DCL VAR(&STARTDATE) TYPE(*CHAR) LEN(16) DCL VAR(&ENDDATE) TYPE(*CHAR) LEN(16) DCL VAR(&W2DATE) TYPE(*CHAR) LEN(8) DCL VAR(&DATE) TYPE(*CHAR) LEN(8) DCL VAR(&TDATE) TYPE(*CHAR) LEN(8) DCL VAR(&HOUR) TYPE(*CHAR) LEN(2) ADDLIBLE LIB(EXTSYSF) MONMSG MSGID(CPF0000) ADDLIBLE LIB(EXTSYS) MONMSG MSGID(CPF0000) ADDLIBLE LIB(XXXXXX) MONMSG MSGID(CPF0000) DLTSPLF FILE(LLCPF4R$) MONMSG MSGID(CPF0000) DLTSPLF FILE(LLGPF6R$) MONMSG MSGID(CPF0000) /* RETRIEVE CURRENT DATE AND HOUR OF DAY */ RTVSYSVAL SYSVAL(QDATE) RTNVAR(&SYSDATE) RTVSYSVAL SYSVAL(QHOUR) RTNVAR(&HOUR) /* &LILIAN WILL CONTAIN THE NUMBER OF DAYS BETWEEN TODAY AND */ /* AND OCT 14, 1582. */ CALLPRC PRC(CEELOCT) PARM(&LILIAN &JUNK1 &JUNK2 *OMIT) /* CONVERT LILLIAN TO MMDDYYYY DATE */ CALLPRC PRC(CEEDATE) PARM(&LILIAN 'MMDDYYYY' &TDATE *OMIT) /* CONVERT LILLIAN TO YYYYMMDD DATE */ CALLPRC PRC(CEEDATE) PARM(&LILIAN 'YYYYMMDD' &DATE *OMIT) /* SUBTRACTING 5 FROM &LILIAN WILL PRODUCE YESTERDAY'S DATE */ CHGVAR VAR(%BIN(&LILIAN)) VALUE(%BIN(&LILIAN) - 5) /* CONVERT LILLIAN TO MMDDYYYY DATE */ CALLPRC PRC(CEEDATE) PARM(&LILIAN 'MMDDYYYY' &WDATE *OMIT) CHGVAR VAR(&YESTERDAY) VALUE(&WDATE) /* RUN EXTOL CMD FOR LATE FUNCTIONAL ACKS BETWEEN TODAY AND 5 DAYS AGO */ PRTACKTP PERIOD((*AVAIL &WDATE) (*AVAIL &TDATE)) + ASTSSLT(*LATE) /* RUN EXTOL CMD TO SHOW INBOUND/OUTBOUND RECEIVE/SEND ERRORS */ PRTCNNSEL PERIOD((*AVAIL &WDATE) (*AVAIL &TDATE)) + RCVSTS(*ERROR) SNDSTS(*ERROR) DLTRPT(*YES) /* CUSTOM REPORTS START HERE */ /* CONVERT LILLIAN TO MMDDYYYY DATE */ CALLPRC PRC(CEEDATE) PARM(&LILIAN 'YYYYMMDD' &W2DATE *OMIT) CHGVAR VAR(&STARTDATE) VALUE(&W2DATE *TCAT '00000000') CHGVAR VAR(&ENDDATE) VALUE(&DATE *TCAT '23599900') /* Envelope Error in Extol */ OVRPRTF FILE(QPQXPRTF) DEVTYPE(*SCS) PAGESIZE(8 10.5 + *UOM) LPI(8) CPI(16.7) FOLD(*YES) + PRTQLTY(*STD) PAGRTT(90) UOM(*INCH) + OUTQ(*JOB) HOLD(*YES) STRQMQRY QMQRY(EXT_ENVERR) OUTPUT(*PRINT) + QMFORM(EDILIB/TEST) SETVAR((DATE + &STARTDATE) (DATEEND &ENDDATE)) DLTOVR FILE(QPQXPRTF) /* Generation Error in Extol */ OVRPRTF FILE(QPQXPRTF) DEVTYPE(*SCS) PAGESIZE(8 10.5 + *UOM) LPI(8) CPI(16.7) FOLD(*YES) + PRTQLTY(*STD) PAGRTT(90) UOM(*INCH) + OUTQ(*JOB) HOLD(*YES) STRQMQRY QMQRY(EXT_GENERR) OUTPUT(*PRINT) + QMFORM(EDILIB/TEST) SETVAR((DATE + &STARTDATE) (DATEEND &ENDDATE)) DLTOVR FILE(QPQXPRTF) /* Translation Error in Extol */ OVRPRTF FILE(QPQXPRTF) DEVTYPE(*SCS) PAGESIZE(8 10.5 + *UOM) LPI(8) CPI(16.7) FOLD(*YES) + PRTQLTY(*STD) PAGRTT(90) UOM(*INCH) + OUTQ(*JOB) HOLD(*YES) STRQMQRY QMQRY(EXT_TRNERR) OUTPUT(*PRINT) + QMFORM(EDILIB/TEST) SETVAR((DATE + &STARTDATE) (DATEEND &ENDDATE)) DLTOVR FILE(QPQXPRTF) /* Unwrap Error in Extol */ OVRPRTF FILE(QPQXPRTF) DEVTYPE(*SCS) PAGESIZE(8 10.5 + *UOM) LPI(8) CPI(16.7) FOLD(*YES) + PRTQLTY(*STD) PAGRTT(90) UOM(*INCH) + OUTQ(*JOB) HOLD(*YES) STRQMQRY QMQRY(EXT_UNWERR) OUTPUT(*PRINT) + QMFORM(EDILIB/TEST) SETVAR((DATE + &STARTDATE) (DATEEND &ENDDATE)) DLTOVR FILE(QPQXPRTF) /* Wrap Error in Extol */ OVRPRTF FILE(QPQXPRTF) DEVTYPE(*SCS) PAGESIZE(8 10.5 + *UOM) LPI(8) CPI(16.7) FOLD(*YES) + PRTQLTY(*STD) PAGRTT(90) UOM(*INCH) + OUTQ(*JOB) HOLD(*YES) STRQMQRY QMQRY(EXT_WRPERR) OUTPUT(*PRINT) + QMFORM(EDILIB/TEST) SETVAR((DATE + &STARTDATE) (DATEEND &ENDDATE)) DLTOVR FILE(QPQXPRTF) ENDPGM