MQSeries.net :: View topic - Common ESQL functions

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 » Common ESQL functions

Common ESQL functions

« View previous topic :: View next topic »

Author

Message

mattfarney

Posted: Fri Jul 13, 2007 2:30 pm Post subject: Common ESQL functions

Disciple

Joined: 17 Jan 2006
Posts: 167
Location: Ohio

Is it possible to create utility functions in ESQL that can be called from inside other filter modules?

For an example, I need to iterate through lists of tags looking for a specific tag. I'm going to do this in several consecutive filter nodes, the only change being the value of the tag.

I would like to move the search logic to an external function in the same esql file, taking in only the tag.

I cannot find the syntax for creating or calling such a construct, let alone passing data into a filter module.

Thanks.
-mf

wbi_telecom

Posted: Fri Jul 13, 2007 2:46 pm Post subject:

Disciple

Joined: 15 Feb 2006
Posts: 188
Location: Harrisburg, PA

Look for "ESQL functions" and "Calling ESQL functions" in Infocenter. Its possible to write esql functions and call them in all data processing nodes. The syntax of the function creation is something like (from memory Pls look in Infocenter to be sure)
CREATE FUNCTION xyz(IN Input REFERENCE) RETURNS <>
BEGIN

More Esql

END;

You have to give the PATH of the functions module on top of the message flow esql module where you will call this function .

Cheers,

AkankshA

Posted: Sun Jul 15, 2007 9:55 pm Post subject:

Grand Master

Joined: 12 Jan 2006
Posts: 1494
Location: Singapore

In case you want for ease of maintenance u can also keep this function in a separete eSQL file.....
_________________
Cheers

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Common ESQL functions

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