Stage variable not defined

[aschand]

Hi

Can any one please let me know what does this error mean and how i should rectify it.

This was the compilation error that i got.

Stage Variable vMTART: if isNull(lnkMatched.MATERIAL_TYPE) then ' '
else trim(lnkMatched.MATERIAL_TYPE)
Variable 'lnkMatched.MATERIAL_TYPE' not defined

thanks and Regards
aschand

[gateleys]

It just says that there is no column or link with that name.
Make sure that you have the input link 'lnkMatched' and the column name 'MATERIAL_TYPE' in that link.

[chulett]

That's an input column / link name that it can't find, not a stage variable. Check your spelling.

[Teej]

Did you change your input link? Or did you just copy and paste old stage variables to a new job?

While DataStage can do a lot to reduce development time, it is still not quite smart enough to understand perfectly what is intended in both of the above situations (and others that I may have not thought about.)

[ray.wurlod]

(and others that I may have not thought about.)

Still thinking about getting it to make lunch, I'll warrant.
Do you get a banquet if you use a parallel job?

[aschand]

Thanks.. It got solved

[ray.wurlod]

Please mark the thread as Resolved and make a post explaining how it was resolved.

[ray.wurlod]

Please mark the thread as Resolved and make a post explaining how it was resolved.