Sqlrpgle

shyedajmal

285 pts.

Tags:

SQLRPGLE

I have two pf are PF1 & PF2. PF1 has 100 records & PF2 has 90 records.how to i find the unmatched records ? PF1 Fields are typ1,typ2 Pf2 Fields are Typ3 ,typ2. plz guide me.....

Software/Hardware used:
AS400

Asked: January 6, 2012 5:25 AM Last updated: March 19, 2012 1:41 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Send me notifications when members answer or reply to this question.

Discuss This Question: 2 Replies

There was an error processing your information. Please try again later.

Thanks. We'll let you know when a new response is added.

Send me notifications when members answer or reply to this question.

TomLiotta Jan 6, 2012 8:41 AM GMT

I assume that the matches would be where typ2 matches in the two files. Try either a NOT IN() subselect or an EXCEPTION JOIN. Without more information about the purpose, that's about all that can be said. Without a business problem statement, it is too close to homework. Tom

125,585 pointsBadges:

report
philpl1jb Jan 6, 2012 8:51 AM GMT

Show us your logic and we'll help. Also, clarify how the files are to be matched. Phil

54,090 pointsBadges:

report