MQSeries.net :: View topic

jugadu · Posted: Wed Dec 24, 2008 4:09 am Post subject:

Hi,

I'm having flow like MQInput-->Compute-->MqOutput.

In Compute node i'm using below code.

SET Environment.Variables.Data[]=PASSTHRU(SELECT QUERY)
IF(CARDINALITY(Environment.Variables.Data[]>0)THEN
WHILE(count <= CARDINALITY(Environment.Variables.Data[]) DO

--Generating XML message.
--check for mandatory field

IF(Environment.Variables.Data[count].CUST_ID IS NULL)THEN
THROW USER EXCEPTION MESSAGE 1 VALUES('TABLE Contains No CUST_ID');
END IF;

PROPAGATE DELETE NONE;
SET count = count+1;

END WHILE;

ELSE
THROW USER EXCEPTION MESSAGE 1 VALUES('TABLE Contains No data for');

----------------------------
The select Query will retieve more than 100 rows. It has to generate each 100 message and propagate to output node.

Problem is if any mandatory field is missing(CUST_ID) in between it will throw an user exception and entire message will roll back.

I wnt to handle this exception and it has to process the next message.

Could u please any one guide me........how to achieve this.......