join versus match
join versus match
(OP)
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
OLD-NOT-NEW
I am using two DB2 database
Thanks
breyt
RE: join versus match
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
RE: join versus match
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'
RE: join versus match
thanks for the information . But with DB I cant use SET ALL=PASS for DB reason (Optimization off)
Thanks for a new Idea
Breyt