Eliminate warnings on empty lookup

Joshi · Post by **Joshi** » Thu Jan 14, 2016 3:18 am

Hello,

I searched the forum but did not find any answer.

The customers developer guide defines jobs to be developed "warning free". I am using a lookup-stage which might be empty. How can I eliminate the warning on the empty lookup stream?

Regards,

Joerg

ArndW · Post by **ArndW** » Thu Jan 14, 2016 7:25 am

Hello Joshi,

An empty lookup stream does not generate a warning in DataStage. What is your "lookup failure" condition - if you set that to "reject" that would cause the job to fail. Also, what is your exact warning message?

Mike · Post by **Mike** » Thu Jan 14, 2016 8:40 am

Actually, I've seen the warning Joshi is referencing several times on my current version 11.3 project... it might be new behavior since I don't ever remember encountering that before.

Your options are to include an extra dummy record in the reference input that will never match anything or use a message handler.

You might want to contact your official support provider to see if there is any other option.

Mike

Joshi · Post by **Joshi** » Thu Jan 14, 2016 9:00 am

Thank you all, I will let the local IBM support team know.

Greetings,

Joerg

ArndW · Post by **ArndW** » Fri Jan 15, 2016 8:32 am

I'm on a 11.x machine and tested my reply yesterday before posting; no warning seen.

Mike · Post by **Mike** » Sat Jan 16, 2016 8:50 am

My current project is not on the latest 11.x fix pack, so maybe that issue has been fixed.

Mike

qt_ky · Post by **qt_ky** » Sat Jan 16, 2016 9:39 am

I'm not seeing any warnings on version 11.3.1.2 with any empty reference file, created empty by using the touch command.

What warning(s) are you finding? Can you share the detailed job log?