Look up not found

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
raji33
Premium Member
Premium Member
Posts: 151
Joined: Thu Sep 23, 2010 9:21 pm
Location: NJ

Look up not found

Post by raji33 »

Hi Gurus,

can any one please help me understand this constraint

(StageVar = 'Y' and lkp.NOTFOUND = @false ) or lkp.NOTFOUND


Thanks
in advance
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

It returns TRUE if (StageVar = 'Y' and the lookup succeeds) or if the lookup fails.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
raji33
Premium Member
Premium Member
Posts: 151
Joined: Thu Sep 23, 2010 9:21 pm
Location: NJ

Post by raji33 »

Thanks chulett
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”