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
 

 

Getting the Non Matching records

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Ketan Varhade

Active User


Joined: 29 Jun 2009
Posts: 197
Location: Mumbai

PostPosted: Fri Feb 12, 2010 4:13 pm    Post subject: Getting the Non Matching records
Reply with quote

Hi,
I have two files and I am matching the files on the basis of the keys. I want to get the non matching records from the files. I have searched the forum there is a post but from it I could not get any information. Can any one please help me to creating the SYSIN card.
I am using the Syncsort for this task.
Is there any other way that I can achive this task.
Back to top
View user's profile Send private message

sril.krishy

Active User


Joined: 30 Jul 2005
Posts: 183
Location: hyderabad

PostPosted: Fri Feb 12, 2010 4:32 pm    Post subject:
Reply with quote

Search the forum with 'JOIN UNPAIRED' .You will get number of solutions.

Thanks
Krishy
Back to top
View user's profile Send private message
Ketan Varhade

Active User


Joined: 29 Jun 2009
Posts: 197
Location: Mumbai

PostPosted: Fri Feb 12, 2010 4:34 pm    Post subject:
Reply with quote

I already tried using that and didn't got the desired output thats why I am asking for some help in detail
Back to top
View user's profile Send private message
Ketan Varhade

Active User


Joined: 29 Jun 2009
Posts: 197
Location: Mumbai

PostPosted: Fri Feb 12, 2010 4:35 pm    Post subject:
Reply with quote

Hi
I am using the following card
Code:

JOINKEYS FILES=F1,FIELDS=(1,197,A,                           
                         72,8,A)                             
JOINKEYS FILES=F2,FIELDS=(125,5,A,                           
                         67,8,A)                             
JOIN UNPAIRED,F1,F2                                           
REFORMAT FIELDS(F1:1,204,F2:1,419)
SORT FIELDS=COPY                                             
OUTFIL FNAMES=SORTOF1,                                       
    INCLUDE=(1,005,CH,NE,C'     ',AND,205,005,CH,NE,C'     '),
    OUTREC(1:1,204)                                           
OUTFIL FNAMES=SORTOF2,                                       
    INCLUDE=(205,005,CH,EQ,C'     '),                         
    OUTREC(1:1,204)                       
OUTFIL FNAMES=SORTOF3,                   
    INCLUDE=(1,005,CH,EQ,C'     '),       
    OUTREC(1:205,419)           
Back to top
View user's profile Send private message
sril.krishy

Active User


Joined: 30 Jul 2005
Posts: 183
Location: hyderabad

PostPosted: Fri Feb 12, 2010 4:43 pm    Post subject:
Reply with quote

Hi,
Please post some dummy input data and the expected output data along with the file attributes.

Thanks
Krishy
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 Feb 12, 2010 4:53 pm    Post subject:
Reply with quote

If you had already searched the forum you may have noticed that the small amount of information that you have bothered to give us is by far too little.

What is the RECFM and LRECL of both files.
What is the position, length and format of the keys on each file.

Ok, so I do not know SYNCSORT, BUT looking at your control statements, and if I am correct in my asssumption
Code:
JOINKEYS FILES=F1,FIELDS=(1,197,A,
                         72,8,A)
JOINKEYS FILES=F2,FIELDS=(125,5,A,
                         67,8,A)

It looks to me as if you are comparing 197 bytes from position 1 from file1 against 5 bytes from position 125 of file2.

As I have said, I do not know the product, but if I am correct, is it likely that these will ever match ?
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Thu Feb 18, 2010 1:21 am    Post subject:
Reply with quote

Ketan,

Expat, is right. The fields you are attempting to JOIN do not have to be in the same positions, but they must be the same length and format in the 2 files.

If you still require assistance, please repost or send me an email offline at alissa.margulies@syncsort.com and I would be happy to further assist you.
Back to top
View user's profile Send private message
Ketan Varhade

Active User


Joined: 29 Jun 2009
Posts: 197
Location: Mumbai

PostPosted: Thu Feb 18, 2010 11:03 am    Post subject:
Reply with quote

Hi All,
I have corrected the sort card mentioned above and got the missing recrods. Thank you all for the inputs.
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts Extract set of records matching on ac... bhaskar_kanteti DFSORT/ICETOOL 3 Mon Mar 06, 2017 7:19 am
No new posts Inserting records based on conditions vickey_dw DFSORT/ICETOOL 9 Wed Feb 22, 2017 1:33 pm


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