I have a file1 with a field account number.
I have another file2 with field Accnum, Security and Qty
AccNum Security Qty
A X 1
A X 3
A Y 2
A Y 3
Now I need to generate a summary file like this by summing up the quantity for those records with same account number and Qty
A X 4
A Y 6
B X 2
C Z 1
Note - File2 can have many account numbers, but I am converned only with A,B and C which are taken from File1.
How can I generate a summary file ? I dont want to use SQL, by normal chain and reade how can I achieve this?