I have 2 files ,file1 & file2 .I need to compare these 2 files for the matched records . from the matched records I need to filter based on a 1 byte indicator.
also for syntax UNPAIRED ,i know that I ll get the records that are in file1 and not in file2 . i tried for JOIN PAIRED to get matched records.but its not working,can some one help me ?
Edited: Please use BBcode when You post some code/error, that's rather readable, Thanks... Anuj
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
Quote:
also for syntax UNPAIRED ,i know that I ll get the records that are in file1 and not in file2 . i tried for JOIN PAIRED to get matched records.but its not working,can some one help me ?
For matched records alone, you dont need the JOIN statement. You can omit the JOIN statement itself if you want ONLY matched records.
Before this join step in proc ,i cretaed an another step which extracted the records(file F1) based on an indicator & i used that file F1 and matched it with F2 ...to get the matched records ...
Thank you Guys,,,
But still ,instead of doing this separately in each step,,can i do it in single SORT,,?
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
selvamphigai wrote:
But still ,instead of doing this separately in each step,,can i do it in single SORT,,?
Yes if I understood this correctly. Modify your sort card as the below one (Untested). From your latest post, you need to filter F1 records based on some indicator and the below sort extracts records having '1' or '2' at 42-pos from F1 before doing a match.Do try this and let us know the results.
so,from the WDHT file ,it will take the records which have IRA code as 1 or 2 & those extracted records will be compared with the second PFLT file for the matched accts.is that right ?
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
selvamphigai wrote:
you hav specifies as 'SS".Can you explain what it is ?
SS stands for Substring - SyncSort for z/OS Programmer's Guide Release 1.3 Page 2.42 lists the detals about SS. There is a reference to SS on some other pages, too.
Quote:
so,from the WDHT file ,it will take the records which have IRA code as 1 or 2 & those extracted records will be compared with the second PFLT file for the matched accts.is that right ?
If what at position 42 of length "1" is called IRA-code (which is someting specific to your environment/files) - then your understanding is correct.