View previous topic :: View next topic
|
Author |
Message |
hcl_ln
New User
Joined: 14 Sep 2005 Posts: 21
|
|
|
|
Hi,
I have a requirement as below.
The records are below. (file is FB).
Code: |
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
9920090811231718000000003 00000000219453
9920090811231718000000001 00000000095099
9920090811231718000000001 00000000029255
|
Col 17-25 is the count of particular recor type
Col 27-40 is the amount filed
Also, somewhere on the right in Col 170, I have a field which is 9 bytes filled up in the same record line.
Now,my requirement is to add these 3 records (only cols 17-25 & 27-40) and space out the 9 byte field in Col 170 and replicate the record as 1 record. That means, it should appear as :
Code: |
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
9920090811231718000000005 00000000343807
|
I searched in the manual but in vain for this type of requirement.
I am not sure if this is a gettable function thru FILE-AID batch. I talked to my friends also but they are also helpless.
Can somebody help please ??
Thanks in advance ! ! ! |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
hcl_ln,
May be TALLY/ACCUM functions are what you're looking for. BTW, Is there any specific reason to go for fileaid batch when you can achieve this using your sort product? |
|
Back to top |
|
|
hcl_ln
New User
Joined: 14 Sep 2005 Posts: 21
|
|
|
|
Thanks you arcvns, for the tip. I will look for it.
Well, the reason behind it in looking for FILE-AID is, there is so much of existing code in production in FILE-AID batch. I was looking for something quick just to add to it. To change it to a SORT card, it would take more time. |
|
Back to top |
|
|
|