MQSeries.net :: View topic - Global procedures in message broker 5.0

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 » Global procedures in message broker 5.0

Global procedures in message broker 5.0

« View previous topic :: View next topic »

Author

Message

Posted: Thu Jan 05, 2006 3:20 am Post subject: Global procedures in message broker 5.0

Apprentice

Joined: 24 May 2002
Posts: 25

Hi,

Is it possible to create global procedures in message broker 5.0 and access it in the esql in my message flow. Can anybody please guide me here ?

Thanks in advance,
d

jefflowrey

Posted: Thu Jan 05, 2006 4:27 am Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

It's possible to create an ESQL file in a message flow project and call the procedures defined in that file from other message flow projects, yes.

Procedures are globally reusable and can be called by other functions or procedures in ESQL files within any schema defined in the same or another project.
_________________
I am *not* the model of the modern major general.

Posted: Thu Jan 05, 2006 8:29 pm Post subject:

Apprentice

Joined: 24 May 2002
Posts: 25

Thank you.

This is the scenario where I want to use it.
I have a request message flow (say AggregationEx) where I use an aggregate control node to send the message to 10 different compute nodes. In each of these compute nodes, I have a common procedure to call plus some coding specific to that compute node. I use a single esql file which has the same name as the message flow. Instead of writing the common procedure in each compute node module, how can I just write the procedure only once in the esql file & call it in each compute node module.

I am quite new to message broker 5.0. Please guide me.

elvis_gn

Posted: Thu Jan 05, 2006 8:35 pm Post subject:

Padawan

Joined: 08 Oct 2004
Posts: 1905
Location: Dubai

Hi d,

Its as Jeff explained.

Define a schema under the flow project. create an esql file there and write ur method in it.

Now from ur flows (within the same project) , in the ESQL, do a Ctrl + Space and u'll find the Schema name there in the list....As in Java, where we do a class.method name...u'll be able to do a schema.method name...

It will reference that method from the common location.

Regards.

Posted: Sun Jan 08, 2006 8:38 pm Post subject:

Apprentice

Joined: 24 May 2002
Posts: 25

Thank you for all your inputs....

I tried it & it worked !!!!

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Global procedures in message broker 5.0

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