senthilarumugam
New User
.jpg)
Joined: 09 May 2006
Posts: 19
Location: chennai
|
|
|
|
Hi,
I have the following requirements.
| Code: |
dept dept-cde point
----- --------- ----------
AAA 001 0.1
AAA 001 0.2
AAA 001 0.3
BBB 002 0.4
BBB 002 0.5
CCC 005 0.6
CCC 005 0.7
CCC 005 0.7
|
I need the ouput like,
| Code: |
dept dept-cde total-point
----- --------- ----------
AAA 001 0.6
BBB 002 0.9
CCC 005 2.0
|
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
Here's a DFSORT job that will do what I think you asked for:
| Code: |
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD *
AAA 001 0.1
AAA 001 0.2
AAA 001 0.3
BBB 002 0.4
BBB 002 0.5
CCC 005 0.6
CCC 005 0.7
CCC 005 0.7
//SORTOUT DD SYSOUT=*
//SYSIN DD *
OPTION COPY
OUTFIL REMOVECC,NODETAIL,
SECTIONS=(1,11,
TRAILER3=(1,20,21:TOT=(21,3,UFF,EDIT=(T.T))))
|
SORTOUT has:
| Code: |
AAA 001 0.6
BBB 002 0.9
CCC 005 2.0
|
|
|
