MQSeries.net :: View topic - eSQL try catch??

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » eSQL try catch??

eSQL try catch??

« View previous topic :: View next topic »

Author

Message

madi

Posted: Mon Mar 20, 2006 11:54 am Post subject: eSQL try catch??

Chevalier

Joined: 17 Jan 2006
Posts: 475

Hi All

I am unbatching an xml file and doing some DB updates all in the same database node.

My question is if one of the unbatched files has an error in it and throws an exception, is there a way to catch it and continue with the other iterations in the loop?

Code:

FOR cursor AS Root.MRM.Receipts.Receipt[] DO

SET Environment.Temp.MaxSeq[] = (SELECT T.A7JC AS Seq FROM Database.RTA.TINR AS T
WHERE T.ANB = FIELDVALUE(cursor.OrderID));
END FOR;

If one of the Receipts[] has no OrderID the entire message in thrown into ERR queue.

plz help
madi

jefflowrey

Posted: Mon Mar 20, 2006 12:19 pm Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r0m0/index.jsp?topic=/com.ibm.etools.mft.doc/ak20700_.htm
_________________
I am *not* the model of the modern major general.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » eSQL try catch??

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP