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: 3068
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 To Omit records based n SORT condition DFSORT/ICETOOL 6
No new posts Looking for help with SORT JCL/SYNC sort DFSORT/ICETOOL 6
No new posts sort to find out the char which repea... Mainframe Interview Questions 10
No new posts Dynamically build sort control statem... SYNCSORT 18
No new posts Format Binary file to EBCDIC JCL & VSAM 4
Search our Forums:

Back to Top