join versus match

[breyt]

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

 

[Tewy]

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

 

[simaccs]

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'

 

[breyt]

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