fork(2) download
  1. //SELAR JOB BDWP,'',MSGCLASS=H,CLASS=9,MSGLEVEL=(1,1),
  2. //* TYPRUN=SCAN,
  3. // REGION=4M, NOTIFY=DWEXTD1, TIME=1440
  4. //*
  5. // STEP010 EXEC PGM =IKJEFT01, REGION=5M, COND=(4,LT)
  6. //* ouput will have only be available in the spool.
  7. //SYSREC00 DD SYSOUT=*
  8. //SYSTSIN DD *
  9. DSN SYSTEM(DB0W)
  10. RUN PROGRAM(DSNTIAUL) PLAN(DSNTIB71) -
  11. LIB('TSGS.DSN710.DBDW.RUNLIB.LOAD') PARMS('SQL')
  12. END
  13. //SYSIN DD *
  14. SELECT
  15. AR_ID
  16. , DECIMAL(SUM(CASE WHEN CHRG_TYPE_ID = 'SCHRG' THEN CHRG_AMNT ELSE 0 END),17,2) S_CHRG
  17. , DECIMAL (SUM(CASE WHEN CHRG_TYPE_ID = 'LHRG' THEN CHRG_AMNT ELSE 0 END),17,2) L_CHG_COLL
  18. , DECIMAL (SUM(CASE WHEN CHRG_TYPE_ID = 'AFEE' THEN CHRG_AMNT ELSE 0 END),17,2) A_FEE
  19. FROM BDWP.TABLE_A A
  20. INNER JOIN BDWP.TABLE_B B
  21. , ON A.PART_COLUMN= B.PART_COLUMN
  22. AND B.MEASURE_PRD='2011-12-31'
  23. GROUP BY AR_ID
  24. ;
  25. //SYSTSPRT DD SYSOUT=*
  26. //SYSPUNCH DD SYSOUT=*
  27. //SYSUDUMP DD SYSOUT=*
  28. //*
Compilation error #stdin compilation error #stdout 0s 0KB
stdin
Standard input is empty
compilation info
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
stdout
Standard output is empty