| Author |
Message |
 Topic: To use propogate inside a loop? |
anoobrocks
Replies: 11
Views: 8073
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 07, 2010 9:10 am Subject: To use propogate inside a loop? |
Try using the options DELETE NONE FINALIZE NONE on the propagate.
Yes it worked when i used Delete none. Thanks a lot. Sorry for the delay in reply. |
| Topic: To use propogate inside a loop? |
anoobrocks
Replies: 11
Views: 8073
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Oct 04, 2010 9:17 am Subject: To use propogate inside a loop? |
| Say.. I am trying to fetch around 10 records from table, do some logic and then propogate to the output Q... I need to do the same process again and again for the next ten records.. like wise nearly 1 ... |
| Topic: To use propogate inside a loop? |
anoobrocks
Replies: 11
Views: 8073
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Oct 04, 2010 8:38 am Subject: To use propogate inside a loop? |
Hi,
set a=1;
while a<=10 do
.
..
...
propagate to terminal 'out1';
set a=a+1;
end while;
Can i know the reason for messages moving to DLQ. As far as i know we can use propagate inside a ... |
| Topic: To select first N number of records?? |
anoobrocks
Replies: 3
Views: 3665
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Oct 03, 2010 3:56 am Subject: To select first N number of records?? |
Thank jeff,
And in my case Rownum is not a column here.. since i need first N records from the table, i tried giving ROWNUM.. guess it doesnt support in ESQL..
As i mentioned before, all i need ... |
| Topic: To select first N number of records?? |
anoobrocks
Replies: 3
Views: 3665
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Oct 03, 2010 2:46 am Subject: To select first N number of records?? |
Hi,
I am using MB6.0 and wanted to select first N number of records from the table based on the value in the UDP (GroupCount).
SET Environment.Variables.output[] = SELECT R.* FROM Database.GROU ... |
| Topic: ESQL Query |
anoobrocks
Replies: 17
Views: 8818
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Sep 28, 2010 4:32 am Subject: ESQL Query |
Thanks all for the reply..
I gave the same ans saying it is possible by position & looping.. the same way as u suggested.. but i was asked to try without usng a loop eventhough i said its not p ... |
| Topic: ESQL Query |
anoobrocks
Replies: 17
Views: 8818
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Sep 28, 2010 3:24 am Subject: ESQL Query |
| I mean to find the number of a specific characters like 'e' or any special char in a string.. position cant help to resolve this.. |
| Topic: ESQL Query |
anoobrocks
Replies: 17
Views: 8818
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Sep 28, 2010 1:45 am Subject: ESQL Query |
Hi,
Can anyone suggest, the keyword/type/statement/function used to find the number of characters in a string without using any loops.
eg) Name='WebsphereMessageBroker', to find the number of 'e' ... |
