IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

Insert a trailer record and count the records.


 
IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: :: View next topic  
Author Message
dharmaraok

New User


Joined: 10 Mar 2011
Posts: 45
Location: india

PostPosted: Thu Dec 19, 2013 10:15 pm
Reply with quote

I am having below INPUT file :

Header
Transaction records

HH0303030 - header
D22221111 - transaction record
D33332222- transaction record.

In my output trailer record should insert with total count of records from position 2 of 4 bytes (including header and transaction records) and sum of the amount field(starts at position 6 and having length 5 bytes ) at 6poistion in the output files.

the output should be:

HH0303030 - header
D22221111 - transaction record
D33332222- transaction record.
T00023333 - Trailer record.

the count and sum of the field should be written into COMP-3 format. the Input also in COMP-3Format.

Could you please let me know . how to achieve this
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19251
Location: Inside the Matrix

PostPosted: Thu Dec 19, 2013 10:28 pm
Reply with quote

Hello,

Which sort product is being used on your system?
Back to top
View user's profile Send private message
dharmaraok

New User


Joined: 10 Mar 2011
Posts: 45
Location: india

PostPosted: Fri Dec 20, 2013 9:56 am
Reply with quote

syncsort
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic All times are GMT + 6 Hours
Forum Index -> JCL & VSAM
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Forum Replies
This topic is locked: you cannot edit posts or make replies. Splice JCL into one record for DD sta... SYNCSORT 2
No new posts Can we Insert duplicates in Primary U... DB2 0
No new posts Copying data from prev record using SORT SYNCSORT 19
No new posts how to get total count from numeric d... SYNCSORT 9
No new posts Break a record into fields, each fiel... SYNCSORT 2

Back to Top