Not(Lookuplink.NotFound)

ranga1970 · Post by **ranga1970** » Tue Feb 01, 2005 1:56 pm

Folks,
I am stepped in to do production support, and found a the job with constraint

Not(Lookuplink.NotFound)

Where lookuplink is link from hash file used to do lookup, my question is
.Notfound is built in function or routene or transform, i never got a chance to work on this kind one before, Any input or suggestions would be great and appreciated,

kcbland · Post by **kcbland** » Tue Feb 01, 2005 1:59 pm

It's an inherent stage variable. It lets you know if the link reference lookup found a row or not.

ketfos · Post by **ketfos** » Tue Feb 01, 2005 2:54 pm

Hi,
It is doing a lookup against the hash file.

You can also use IsNull function if NotFound confuses you.
IsNull tests is a variable has null value.

Ketfos

ranga1970 · Post by **ranga1970** » Tue Feb 01, 2005 3:07 pm

got the anwer, thanks, previously I was using IsNull only, but wanted to double check, thanks folks

ray.wurlod · Post by **ray.wurlod** » Tue Feb 01, 2005 4:39 pm

Beware that variable names are case sensitive. The name of this input link variable is NOTFOUND (not NotFound).