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

ICETOOL or SORT - compare data between records of same input


IBM Mainframe Forums -> FAQ & Basics
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
subhadrasn

New User


Joined: 01 Mar 2022
Posts: 6
Location: India

PostPosted: Tue Mar 01, 2022 5:06 pm
Reply with quote

Hi,

I have a requirement to compare data from different records of same input file.

For example: My input layout:
Code:
F1|F2|F3|F4|F5|F6

001|111111|ac|0909099|india|12
221|222222|ac|0909099|india|12
332|333333|ac|0909099|india|12
001|887333|ac|9876553|china|12

My Output file should look like

Code:
001|111111|,|221|222222|,|332|333333|ac|0909099|india|12


Can this comparison and record append be done in sort or icetool please
Coded
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


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

PostPosted: Tue Mar 01, 2022 5:19 pm
Reply with quote

Welcome !
Yes it is possible and discussed on this forum numerous times. Please use SEARCH button on the top to find it and use code tags when representing code or data going forward.
e.g .
ibmmainframes.com/about23725.html
ibmmainframes.com/about23551.html
ibmmainframes.com/about52216.html
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 2022
Location: USA

PostPosted: Tue Mar 01, 2022 7:54 pm
Reply with quote

One more link

Mainframe Tech Help Forum for Beginners
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> FAQ & Basics

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts TRIM everything from input, output co... DFSORT/ICETOOL 1
No new posts Store the data for fixed length COBOL Programming 1
No new posts Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
Search our Forums:

Back to Top