MQSeries.net :: View topic - Regarding user defined ESQL function.

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 » Regarding user defined ESQL function.

Regarding user defined ESQL function.

« View previous topic :: View next topic »

Author

Message

Srinu

Posted: Mon Mar 13, 2006 9:32 am Post subject: Regarding user defined ESQL function.

Acolyte

Joined: 15 Jun 2005
Posts: 51

Hi,

In my present scenario, I giving an XML message(two elements, one with integer value and other with string value) and i want to concat those two values and then map the concatinated string to an element in mapping node. For this I have written a user defined function in message flow ESQL file. After adding this project to bar file and when I try to deploy to broker I am getting an error as "Undefined function " function name".

Thanks in advance,

Srinu

narendrach

Posted: Mon Mar 13, 2006 11:25 am Post subject:

Voyager

Joined: 29 Jun 2005
Posts: 78

CREATE FUNCTION concatValues(IN val INTEGER, IN str CHAR) RETURNS CHAR
BEGIN
return str || ' plus int val ' || CAST(val AS CHAR);
END;

IN ESQL Write the above code

and in Mapping editor pane use this call

esql:concatValues($source/simple/int, $source/simple/str).
_________________
Narendra CH

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Regarding user defined ESQL function.

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