fork download
  1.  
  2. DSN SYSTEM(DB0W)
  3. RUN PROGRAM(DSNTIAUL) PLAN(DSNTIB71) -
  4. LIB('TSGS.DSN710.DBDW.RUNLIB.LOAD') PARMS('SQL')
  5. END
  6. //SYSIN DD *
  7. SELECT
  8. AR_ID
  9. , DECIMAL(SUM(CASE WHEN CHRG_TYPE_ID = 'SCHRG' THEN CHRG_AMNT ELSE 0 END),17,2) S_CHRG
  10. , DECIMAL (SUM(CASE WHEN CHRG_TYPE_ID = 'LHRG' THEN CHRG_AMNT ELSE 0 END),17,2) L_CHG_COLL
  11. , DECIMAL (SUM(CASE WHEN CHRG_TYPE_ID = 'AFEE' THEN CHRG_AMNT ELSE 0 END),17,2) A_FEE
  12. FROM BDWP.TABLE_A A
  13. INNER JOIN BDWP.TABLE_B B
  14. , ON A.PART_COLUMN= B.PART_COLUMN
  15. AND B.MEASURE_PRD='2011-12-31'
  16. GROUP BY AR_ID
  17. ;
  18. //SYSTSPRT DD SYSOUT=*
  19. //SYSPUNCH DD SYSOUT=*
  20. //SYSUDUMP DD SYSOUT=*
  21. //*
Compilation error #stdin compilation error #stdout 0s 0KB
stdin
Standard input is empty
compilation info
prog.cob:1: Warning: Invalid indicator 'S' at column 7
prog.cob:6: Warning: Invalid indicator 'I' at column 7
prog.cob:8: Warning: Invalid indicator 'I' at column 7
prog.cob:13: Warning: Invalid indicator '.' at column 7
prog.cob:18: Warning: Invalid indicator 'U' at column 7
prog.cob:19: Warning: File not terminated by a newline
prog.cob:2: Error: syntax error, unexpected WORD, expecting PROGRAM_ID
stdout
Standard output is empty