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

Getting the Non Matching records


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
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
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
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
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
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
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: 8797
Location: Welsh Wales

PostPosted: Fri Feb 12, 2010 4:53 pm
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: 496
Location: USA

PostPosted: Thu Feb 18, 2010 1:21 am
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Join multiple records using splice DFSORT/ICETOOL 5
No new posts EZT program to build a flat file with... All Other Mainframe Topics 9
No new posts JCL sortcard to print only the records DFSORT/ICETOOL 11
Search our Forums:

Back to Top