| Author |
Message
|
| John |
 Posted: Thu Oct 17, 2002 4:35 pm Post subject: Message Count |
 |
|
Novice
Joined: 21 Apr 2002
Posts: 23
|
May I know how to output the count of messages after filter in MQSI flow?
For example,
MQInput Node --> Filter --> Output
10 messages comes in the and 8 meet the filter criteria. Would like to output the number 8 at the end.
Please advise how to handle this. Thanks a lot in advance.
Thanks. |
|
| Back to top |
|
 |
| kirani |
| Posted: Thu Oct 17, 2002 5:35 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
You will have to make use of some persistent storage to store the counter. Each time when message passes thru the Filter node, you could increment a counter in Database/Shared memory or file.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| John |
| Posted: Thu Oct 17, 2002 6:13 pm Post subject: |
|
|
Novice
Joined: 21 Apr 2002
Posts: 23
|
| Thanks Kiran. Could you please provide further information on how to do that? |
|
| Back to top |
|
|
| kirani |
| Posted: Thu Oct 17, 2002 6:29 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
John,
You will have to create a database table with single integer field to store count. In the filter node, you could increment this counter by 1 each time when the condition is evaluated to true. Once you get last message, you could retrieve final counter value and send it in the output message.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| John |
| Posted: Thu Oct 17, 2002 6:37 pm Post subject: |
|
|
Novice
Joined: 21 Apr 2002
Posts: 23
|
Thanks again Kiran.
May I know where & how to create a database table? What should be the additional ESQL statement in the filter node? Thanks again. |
|
| Back to top |
|
|
| kirani |
| Posted: Thu Oct 17, 2002 6:46 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
|
| Back to top |
|
|
| John |
| Posted: Thu Oct 17, 2002 6:53 pm Post subject: |
|
|
Novice
Joined: 21 Apr 2002
Posts: 23
|
| Thank you very much Kiran. |
|
| Back to top |
|
|
|
|
