Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

join versus match

Status
Not open for further replies.
breyt

breyt

IS-IT--Management
Dec 9, 2002
66
FR
Hi I would like to replace a match file by a join for performance reason. How I can specify the option
OLD-NOT-NEW
I am using two DB2 database
Thanks
breyt
 
Sort by date Sort by votes
Hi Breyt,

When I did my focus training (what seems like many years ago now), I was told the following:

SET ALL=OFF is the same as MATCH .... OLD-AND-NEW
SET ALL=ON is the same as MATCH .... OLD
SET ALL=PASS is the same as MATCH .... OLD-NOT-NEW

I have never tested the above so I suggest you do some small scale tests first.

Regards

Tewy
 
Upvote 0 Downvote
Hi

Try this way.

SET ALL=PASS
JOIN fieldname1 IN file1 TO fieldname2 IN file2

and in following table request

WHERE file2.fieldname2 EQ ' ' OR MISSING

this can work same as 'OLD-NOT-NEW'



 
Upvote 0 Downvote
HI
thanks for the information . But with DB I cant use SET ALL=PASS for DB reason (Optimization off)
Thanks for a new Idea
Breyt
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ekl0908
  • Locked
  • Question
Can I create a JOIN which uses two different keys depending on a field in the file?
Replies
0
Views
297
ekl0908
ekl0908
tracisell
  • Locked
  • Question
Left outer join error
Replies
2
Views
353
FrankExp
FrankExp
kaeserea
  • Locked
  • Question
Join Error 1
Replies
3
Views
246
focwizard
focwizard
oceannative
  • Locked
  • Question
Linear Join using three files; two files twice
Replies
1
Views
163
focwizard
focwizard
kaeserea
  • Locked
  • Question
Join of 4 tables 2
Replies
3
Views
218
focwizard
focwizard

Part and Inventory Search

Sponsor

Back
Top