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

To compare two files and print only the matched records


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
vinit

New User


Joined: 31 Jul 2006
Posts: 8
Location: TCS, INDIA

PostPosted: Wed Feb 28, 2007 11:41 am
Reply with quote

i want to check two files and print the record which is present only in either of the files in a third file
How to proceed on this in JCL
Back to top
View user's profile Send private message
manihcl85
Warnings : 1

New User


Joined: 11 Jan 2007
Posts: 52
Location: chennai

PostPosted: Wed Feb 28, 2007 11:44 am
Reply with quote

Hi,

JCL cant be used for comparision, looping and all, it is just an control language. DFSORT is good for ur requirment.

Regards,
Mani
Back to top
View user's profile Send private message
h.dinesh

New User


Joined: 06 Dec 2006
Posts: 46
Location: Chennai

PostPosted: Wed Feb 28, 2007 3:19 pm
Reply with quote

Vinit,

Read this post, it should help you... icon_neutral.gif

http://ibmmainframes.com/viewtopic.php?t=16806

Dinesh
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


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

PostPosted: Wed Feb 28, 2007 9:20 pm
Reply with quote

Vinit,

Please show an example of the records in each input file and the expected output records. Give the starting position, length and format of the relevant fields (e.g. the key for checking dups). Also, what is the RECFM and LRECL of your input files?
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 -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts Write line by line from two files DFSORT/ICETOOL 7
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
Search our Forums:

Back to Top