View previous topic :: View next topic
|
Author |
Message |
Krishnamurthy
New User
Joined: 05 Nov 2006 Posts: 4
|
|
|
|
Hi
I have an input file as follows
Code: |
ACCT NO DATE AMOUNT
324167453 11/04/2006 $6,603,039.84
125347918 11/04/2006 $7,145.02-
820014986 11/03/2006 $23,498,219.41
|
I want to Sum up the Amount field Based on the Date. The length of the
Amount field is 15 Bytes from Column 56 To 70 and the 70th Column is Signed Bit. It may be spaces or it may have a Minus Symbol, based the Value.
The Output file should be as follows
Code: |
11/04/2006 6595894.82
11/03/2006 23498219.41
|
Please let me know how to do it using DFSort.
With Regards,
Krish |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Here's a DFSORT job that will do what you asked for. I didn't know where you wanted the negative sign for the output records, so I assumed you wanted it before the number. If not, change the EDIT and SIGNS values as needed.
Code: |
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=... input file
//SORTOUT DD DSN=... output file
//SYSIN DD *
OPTION COPY
OUTFIL REMOVECC,NODETAIL,
SECTIONS=(36,10,
TRAILER3=(36,10,
15:TOT=(56,15,SFF,EDIT=(SIIIIIIIT.TT),SIGNS=(,-))))
/*
|
|
|
Back to top |
|
|
Krishnamurthy
New User
Joined: 05 Nov 2006 Posts: 4
|
|
|
|
Thanks a lot...It's working fine.
Regards,
Krish |
|
Back to top |
|
|
|