MQSeries.net :: View topic - Mapping node - Ext ESQL fun passing reference

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 » Mapping node - Ext ESQL fun passing reference

Mapping node - Ext ESQL fun passing reference

« View previous topic :: View next topic »

Author

Message

pvemuri

Posted: Mon May 07, 2007 4:11 pm Post subject: Mapping node - Ext ESQL fun passing reference

Voyager

Joined: 05 Jan 2004
Posts: 83
Location: CA, USA

I am trying to invoke an external ESQL function from a mapping node. The source message set for the mapping node is created from a SAP Business Object and contains namespaces.

I have a structure e2edka1003 that occurs multiple times. Heres how it is defined in the message set:

Code:

$source/tns1:ordersex/tns1:Data_record/ordersex_cwdata:ordersex_cwdata/ordersex_cwdata:ordersex_e2edka1003/ordersex_e2edka1003:ordersex_e2edka1003/ordersex_e2edka1003:PARVW

I want to pass the following as a reference to an external ESQL function as:

Code:

ExtFunc($source/tns1:ordersex/tns1:Data_record/ordersex_cwdata:ordersex_cwdata/ordersex_cwdata:ordersex_e2edka1003)

ordersex_e2edka1003 contains multiple ordersex_e2edka1003[]'s .

I started writing the esteranal function as:

CREATE FUNCTION ExtFunc (myRef REFERENCE) RETURNS CHAR
BEGIN
DECLARE ref1 REFERENCE TO myRef.ordersex_e2edka1003[1];

...

It does not work at all. It shows some Unresolved error. may be I need to decalre a name space and say myRef:NS1.ordersex_e2edka1003[1];

I Just dont know how this works.... is there any information page anywhere?

Monk

Posted: Wed May 09, 2007 1:53 am Post subject:

Master

Joined: 21 Apr 2007
Posts: 282

Why are u referenring a refernce variable.
What i mean is you dont need to create ref1 to reference myref.

In your main code u need to create a refernce(whereever it points to..)
and then pass that to your ESQL function as a parameter
and then do whatever processing you want..in your External function.
_________________
Thimk

pvemuri

Posted: Wed May 09, 2007 10:14 am Post subject:

Voyager

Joined: 05 Jan 2004
Posts: 83
Location: CA, USA

But I am callng the external function from a mapping node from where I can only send a xpath right. Can we send a reference through mapping node?

whytec

Posted: Thu May 10, 2007 8:33 pm Post subject:

Apprentice

Joined: 28 Nov 2005
Posts: 26
Location: Brisbane Australia

In my experience, passing the path in a function is that same as passing a reference. All of the code we write uses functions and procedures, and the majority of them accept a REFERENCE and they are all called passing the fully qualified path rather than creating a reference and passing it.

The only difference between what I've done before and what you're doing is you are using namespaces. Maybe this has something to do with your error?

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Mapping node - Ext ESQL fun passing reference

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