IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Sort to include records of file 2 into file 1


IBM Mainframe Forums -> Java & MQSeries
Post new topic   This topic is locked: you cannot edit posts or make replies.
View previous topic :: View next topic  
Author Message
krunal7757

New User


Joined: 01 Sep 2021
Posts: 6
Location: INdia

PostPosted: Mon Sep 20, 2021 10:28 pm
Reply with quote

Infile 1
000000000001H 09092021
000000000001XA11000010000000010000009092021 09082021 TESTDATA1
000000000001XB11000010100000020000009092021 09082021 TESTDATE2
000000000001T0000000004000000300000

Infile 2
000000000001SC11000010000000010000009092021 09082021
000000000001SD11000010100000020000009092021 09082021

I need to merge the data of file 2 to file . with change to only trailer reocrd having the count of detail record and total of amt. But when i try to merge recrods get appended below the trailer count and one more final traile is created. I need just one trailer per account level updating total count with data in file2
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3098
Location: NYC,USA

PostPosted: Tue Sep 21, 2021 7:51 am
Reply with quote

Duplicate
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies. View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Java & MQSeries

 


Similar Topics
Topic Forum Replies
No new posts Simplify SORT CARD to combine INREC a... DFSORT/ICETOOL 6
No new posts Sort card to generate the DSN DFSORT/ICETOOL 17
No new posts Sort card to know that creation date ... DFSORT/ICETOOL 10
No new posts Convert CSV to flat file. DFSORT/ICETOOL 6
No new posts Multiple INSPECTS on a big size file COBOL Programming 6
Search our Forums:


Back to Top