Could it be possible that the link.NOTFOUND function have a bug in datastage 6, I was all the week traing to make it works , I tested it in every way I imagied, but its still not working. The problem is the following, when I make a relation between to tables and I ask if the relation was null using link.NOTFOUND in the constraint of the destination table but it retrives me all the rows when its supossend not to do that, it works if I use the function isnull(), where am I commiting the mistake?
greeting,
Fer
NOTFOUND function dont work in DS 6
Moderators: chulett, rschirm, roy
Re: NOTFOUND function dont work in DS 6
Yes, it's certainly not out of the realm of possibility.Fersca wrote:Could it be possible that the link.NOTFOUND function have a bug in datastage 6
Back in the day, before the NOTFOUND was added, the only way to check the success of a hash lookup was the IsNull function. When NOTFOUND was first introduced, I started trying to use it and found to my horror that it didn't always work!
![Shocked :shock:](./images/smilies/icon_eek.gif)
Now, I'm sure it works perfectly fine now, however old habits die hard and I see no burning need to switch.
You might want to post your exact 6.x version of DataStage and see if there is a higher maintenance release available. Either that or upgrade into the 7.x family... preferably 7.5.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers