//SELAR JOB BDWP,'',MSGCLASS=H,CLASS=9,MSGLEVEL=(1,1),
//* TYPRUN=SCAN,
// REGION=4M, NOTIFY=DWEXTD1, TIME=1440
//*
// STEP010 EXEC PGM =IKJEFT01, REGION=5M, COND=(4,LT)
//* ouput will have only be available in the spool.
//SYSREC00 DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB0W)
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIB71) -
LIB('TSGS.DSN710.DBDW.RUNLIB.LOAD') PARMS('SQL')
END
//SYSIN DD *
SELECT
AR_ID
, DECIMAL(SUM(CASE WHEN CHRG_TYPE_ID = 'SCHRG' THEN CHRG_AMNT ELSE 0 END),17,2) S_CHRG
, DECIMAL (SUM(CASE WHEN CHRG_TYPE_ID = 'LHRG' THEN CHRG_AMNT ELSE 0 END),17,2) L_CHG_COLL
, DECIMAL (SUM(CASE WHEN CHRG_TYPE_ID = 'AFEE' THEN CHRG_AMNT ELSE 0 END),17,2) A_FEE
FROM BDWP.TABLE_A A
INNER JOIN BDWP.TABLE_B B
, ON A.PART_COLUMN= B.PART_COLUMN
AND B.MEASURE_PRD='2011-12-31'
GROUP BY AR_ID
;
//SYSTSPRT DD SYSOUT=*
//SYSPUNCH DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//*
Ly9TRUxBUiBKT0IgQkRXUCwnJyxNU0dDTEFTUz1ILENMQVNTPTksTVNHTEVWRUw9KDEsMSksCi8vKiBUWVBSVU49U0NBTiwKLy8gUkVHSU9OPTRNLCBOT1RJRlk9RFdFWFREMSwgVElNRT0xNDQwCi8vKgovLyBTVEVQMDEwIEVYRUMgUEdNID1JS0pFRlQwMSwgUkVHSU9OPTVNLCBDT05EPSg0LExUKQovLyogb3VwdXQgd2lsbCBoYXZlIG9ubHkgYmUgYXZhaWxhYmxlIGluIHRoZSBzcG9vbC4KLy9TWVNSRUMwMCBERCBTWVNPVVQ9KgovL1NZU1RTSU4gREQgKgpEU04gU1lTVEVNKERCMFcpClJVTiBQUk9HUkFNKERTTlRJQVVMKSBQTEFOKERTTlRJQjcxKSAtIApMSUIoJ1RTR1MuRFNONzEwLkRCRFcuUlVOTElCLkxPQUQnKSBQQVJNUygnU1FMJykKRU5ECi8vU1lTSU4gREQgKiAKU0VMRUNUCiAgIEFSX0lECiwgIERFQ0lNQUwoU1VNKENBU0UgV0hFTiBDSFJHX1RZUEVfSUQgPSAnU0NIUkcnIFRIRU4gQ0hSR19BTU5UIEVMU0UgMCBFTkQpLDE3LDIpIFNfQ0hSRwosIERFQ0lNQUwgKFNVTShDQVNFIFdIRU4gQ0hSR19UWVBFX0lEID0gJ0xIUkcnIFRIRU4gIENIUkdfQU1OVCBFTFNFIDAgRU5EKSwxNywyKSBMX0NIR19DT0xMCiwgREVDSU1BTCAoU1VNKENBU0UgV0hFTiBDSFJHX1RZUEVfSUQgPSAnQUZFRScgVEhFTiBDSFJHX0FNTlQgRUxTRSAwIEVORCksMTcsMikgQV9GRUUKRlJPTSBCRFdQLlRBQkxFX0EgQQpJTk5FUiBKT0lOIEJEV1AuVEFCTEVfQiBCCiwgT04gQS5QQVJUX0NPTFVNTj0gQi5QQVJUX0NPTFVNTgpBTkQgQi5NRUFTVVJFX1BSRD0nMjAxMS0xMi0zMScKR1JPVVAgQlkgQVJfSUQKOwovL1NZU1RTUFJUIEREIFNZU09VVD0qCi8vU1lTUFVOQ0ggREQgU1lTT1VUPSoKLy9TWVNVRFVNUCBERCBTWVNPVVQ9KgovLyo=
prog.cob:1: Warning: Invalid indicator 'R' at column 7
prog.cob:5: Warning: Invalid indicator 'p' at column 7
prog.cob:13: Warning: Invalid indicator 'I' at column 7
prog.cob:15: Warning: Invalid indicator 'I' at column 7
prog.cob:20: Warning: Invalid indicator '.' at column 7
prog.cob:25: Warning: Invalid indicator 'U' at column 7
prog.cob:26: Warning: File not terminated by a newline
prog.cob:1: Error: syntax error, unexpected WORD, expecting PROGRAM_ID