devmisra
New User
Joined: 29 Jan 2009 Posts: 39 Location: India
|
|
|
|
Hi d.sch,
You are absolutely correct on this approach.
Actually, I am generating a VB file which will contain around 200k records. To review the file data with table data, i need to know the Sum of the amount fields. I thought SORT will be an easier way to achieve the Total amounts. The whole process is not for production, only to review Test/QA data.
When i went thru the SORT cards I learnt PARSE function, so it got more interesting when i tested and got the result.... :-) |
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
When PARSEing you might be able to sum the amount fields by using UFF if they will always be positive or SFF if they are allowed to be negative also.
I'm not able to try this just now, but thought i'd at least pass it along.
Good luck |
|