MQSeries.net :: View topic - Using a filter node to check a vlue to process

LH33 · Posted: Wed Mar 26, 2003 8:29 am Post subject:

Hi!

I have a message flow that reads a formatted XML message off a queue. I use a Filter node to check a database value to determine if I want to write the error to another queue or ignore the message. Can someone look at the following code in my Filter node and see what I may be doing wrong? Also, I cannot find any helpful documentation on what to wire the Unknown and Failure terminals to - or if I ned to. Any suggestions would be appreciated! Note: - The value of LOG_ERROR in the database is equal to 'Y'

Thanks, LisaB

DECLARE TmpFlag Char;
SET TmpFlag = THE (SELECT ITEM L.LOG_ERROR
from Database.BGE_BROKER_ENV_VARS as L
Where L.MSG_FLOW_ID = 'ODLEmerMaintErrors');
If TmpFlag = 'Y' Then
return true;
else
return false;