Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Comparing 2 files using ICETOOL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
creativity

New User


Joined: 10 Feb 2006
Posts: 3
Location: India

PostPosted: Fri May 18, 2007 4:29 pm    Post subject: Comparing 2 files using ICETOOL
Reply with quote

I have two files FILEA and FILEB. FILEA has LRECL = 170 while FILEB has LRECL = 30. Position 1-16 of both files refer to ID number. I need to created three output files in the following way.

OUTFILE1 should contain matching record of FILEA and FILEB,
OUTFILE2 should contain non matching record that appear only in FILEA
OUTFILE3 should contain non matching record that appear only in FILEB

e.g.:

FILEA :

11111111111111111111NAME1.........................
22222222222222222222NAME1.........................
33333333333333333333NAME1.........................
44444444444444444444NAME1.........................
55555555555555555555NAME1.........................

FILEB :

22222222222222222222
55555555555555555555
66666666666666666666
77777777777777777777

The output should be:

OUTFILE1
-----------
22222222222222222222
55555555555555555555

OUTFILE2
-----------
11111111111111111111
33333333333333333333
44444444444444444444

OUTFILE3
-----------
66666666666666666666
77777777777777777777


Please help me out in this. Its Urgent.
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri May 18, 2007 4:40 pm    Post subject:
Reply with quote

And the topic which was top of the forum before your post deals with this.

http://ibmmainframes.com/viewtopic.php?t=21030
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Sun May 27, 2007 12:15 am    Post subject:
Reply with quote

You can use the technique shown in the "Create files with matching and non-matching records" Smart DFSORT Trick at:

http://www.ibm.com/servers/storage/support/software/sort/mvs/tricks/

You'll need to pad the 30 byte records to 170 bytes.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts getting three output files out of JOI... migusd SYNCSORT 7 Mon Jun 05, 2017 11:30 pm
No new posts Using ICETOOL, how we can seperate th... bshkris SYNCSORT 5 Tue May 09, 2017 8:33 pm
No new posts Unable to create multiple files using... mbattu COBOL Programming 3 Fri May 05, 2017 5:35 pm
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm
No new posts Dynamic split of files under groups sril.krishy DFSORT/ICETOOL 4 Mon Apr 17, 2017 1:09 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us