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: 3076
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 ISRDSLST(3.4) Do not include addition... TSO/ISPF 0
No new posts JCL sort to compare dates in two file... DFSORT/ICETOOL 2
No new posts Is this possible via sort (in one pass)? SYNCSORT 4
No new posts combine multiple unique records into ... DFSORT/ICETOOL 2
No new posts GDG generation name to GDG Base name ... DFSORT/ICETOOL 3
Search our Forums:

Back to Top