| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| skipping event processing of databaseinput node |
« View previous topic :: View next topic » |
| Author |
Message
|
| csongebalazs |
 Posted: Thu Jan 24, 2013 6:54 am Post subject: skipping event processing of databaseinput node |
 |
|
Voyager
Joined: 30 Jan 2004
Posts: 78
|
Hi,
I playing with DB input node and has a question.
In that scenario, when event table contains TABLE, ID_COL, ID_VALUE colums, and a STATUS, and in ReadEvents events selected up if status = {something} and those 3 columns are not null.
In BuildMessage SET Root.DataObject.bla bla made by an EVAL statement.
I handled that case when TABLE and ID_COL values are incorrect and resulting ORA errors, but tried to handle those cases, when a valid statement results zero row for the event. In this case i tried to avoid message propagation with a RETURN FALSE; statement. During the deploy i got an error message. It indicates me, i cannot use RETURN FASLE statement in this EQSL. Why?
Of course i can handle empty results after a message propagation (in the next compute node), but want to know, is it possible to do it in this node?
/So plan was: Skip propagation in BuildMessage + store the info about skip happened in an environment variable, then in EndEvent update STATUS based on this environment info/ |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Thu Jan 24, 2013 6:59 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Jan 24, 2013 7:06 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| presumably "RETURN FASLE" was a typo here, and not in your code? |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Jan 24, 2013 7:07 am Post subject: Re: skipping event processing of databaseinput node |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| csongebalazs wrote: |
During the deploy i got an error message. It indicates me, i cannot use RETURN FASLE statement in this EQSL. Why?
|
I hope this was a typo. Either in the posting or in your code. 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
