ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Question Regarding the ESQL Variable

Post new topic  Reply to topic
 Question Regarding the ESQL Variable « View previous topic :: View next topic » 
Author Message
satyasheel15
PostPosted: Mon Jul 07, 2003 12:05 am    Post subject: Question Regarding the ESQL Variable Reply with quote

Voyager

Joined: 04 Mar 2003
Posts: 86

Question:

I have for example 100 messages in the INPUT QUEUE. Now I have to set up an COUNTER which will add in the TAG <TMACCTNO> in the COMPUTE NODE, everytime 100 messages passes through the COMPUTE NODE. This we need to keep track of how many messages from through the COMPUTE NODE and go to OUTPUT NODE and using that count we will track the INPUT AND OUTPUT MESSAGES.But what is happening that everytime COUNTER is RESET TO 1 whenever new messages come to COMPUTE NODE from INPUT NODE.
So please tell how to declare a STATIC TYPE OF VARIABLE IN THE ESQL CODE.

Please advise.

Regards Always

SATYASHEEL
Back to top
View user's profile Send private message Send e-mail MSN Messenger
Yanghui
PostPosted: Mon Jul 07, 2003 12:44 am    Post subject: Reply with quote

Disciple

Joined: 08 May 2002
Posts: 151
Location: Dublin, Ireland

Hi, there,

Have you thought of using the PlugIn node for storing temporary data in memory (SupportPac IA91)? I think it might be useful in this scenario. Sorry I can't give you a certain answer since I never try it myself.

Regards

-Yanghui
Back to top
View user's profile Send private message Send e-mail
mq_series
PostPosted: Mon Jul 07, 2003 1:28 am    Post subject: Reply with quote

Apprentice

Joined: 29 Oct 2001
Posts: 30

Hi,

I think you can store the counter value in a database or some queue and check it from there.I don't know whether this is the only option.

Regards

rkv
Back to top
View user's profile Send private message
satyasheel15
PostPosted: Mon Jul 07, 2003 1:29 am    Post subject: Information regarding the ESQL Variable Reply with quote

Voyager

Joined: 04 Mar 2003
Posts: 86

Hi,

Thanks for your reply. Couldn't we implement the without using the Java PlugIn NOde. Is there any solution available by using ESQL.

Please let me know.

Regards ALways

Satyasheel
Back to top
View user's profile Send private message Send e-mail MSN Messenger
jefflowrey
PostPosted: Mon Jul 07, 2003 6:03 am    Post subject: Re: Information regarding the ESQL Variable Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

satyasheel15 wrote:
Couldn't we implement the without using the Java PlugIn NOde. Is there any solution available by using ESQL.


Each time a message is read by WMQI, the associated message flow is started up from scratch (brand new).

This means that there is no built-in state kept BETWEEN messages with plain ESQL.

The three widely used options for storing this kind of state are to use a custom plug-in, a queue or a database.
Back to top
View user's profile Send private message
JT
PostPosted: Wed Jul 09, 2003 12:15 pm    Post subject: Reply with quote

Padawan

Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.

Not sure if the PostIt plug-in will satisfy your requirement, but it can be used to share data between message flows.
Take a look: http://www-3.ibm.com/software/integration/support/supportpacs/individual/ia0h.html
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Question Regarding the ESQL Variable
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
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.