MQSeries.net :: View topic - Using index value of array Inside mapping file

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 » Using index value of array Inside mapping file

Using index value of array Inside mapping file

« View previous topic :: View next topic »

Author

Message

ajayrana

Posted: Mon May 12, 2014 10:25 pm Post subject: Using index value of array Inside mapping file

Apprentice

Joined: 08 May 2014
Posts: 35

HI,

I am trying to update a table through a mapping file inside a for each transform. The update where clause is

EMI.CREDIT_CARDS.ACCOUNT_NUMBER = ?

Xpath expression :
? | $MessageAssembly/EXBS/body[1]/ACCOUNT_NUMBER

My question is since the messages are coming from an array how do i dynamically update the index value [1] in the Xpath expression ??

Thanks in advance !!

Regards
Ajay Rana

Last edited by ajayrana on Tue May 27, 2014 10:29 pm; edited 1 time in total

ajayrana

Posted: Mon May 12, 2014 11:19 pm Post subject:

Apprentice

Joined: 08 May 2014
Posts: 35

Hi All,

Found the solution to update inside the for each loop with Xpath expression.

The Xpath value should be :

$body/ACCOUNT_NUMBER

and not

$MessageAssembly/EXBS/body[1]/ACCOUNT_NUMBER

because with the for each we are sending the current body only and we dont need to mention the whole path.

-Ajay Rana

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Using index value of array Inside mapping file

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