ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum IndexWebSphere Message Broker Supportauto increment value on attribute on mapping node

Post new topicReply to topic
auto increment value on attribute on mapping node View previous topic :: View next topic
Author Message
mpong
PostPosted: Fri Mar 31, 2017 9:25 am Post subject: auto increment value on attribute on mapping node Reply with quote

Centurion

Joined: 22 Jan 2010
Posts: 108

I have (for each) mapping on mapping node, where the target xsd has attribute called id, which need to be assigned from 0 to n based on the number of for each.

I have an option to assign a value on the attribute but I am not sure how can i increment it by 1 for every for each, I don't want to implement outside of map node.

Still trying but no luck yet, pls let me know your thoughts[/img]
Back to top
View user's profile Send private message
DeadPool
PostPosted: Mon Apr 03, 2017 7:36 am Post subject: Reply with quote

Apprentice

Joined: 27 May 2016
Posts: 29

I am assuming this is not a case of just cardinality but rather a check of what has been done looking at teh previous number and then adding 1 and entering that number.

I suspect you may have to write a custom esql or java transform to do this which would be callable within the mapping

Not the ideal way but is atleast 1 way
Back to top
View user's profile Send private message
mqjeff
PostPosted: Mon Apr 03, 2017 8:33 am Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17267

A foreach and a submap?
_________________
Read, Think, Try, Repeat
Back to top
View user's profile Send private message
timber
PostPosted: Mon Apr 03, 2017 8:41 am Post subject: Reply with quote

Yatiri

Joined: 25 Aug 2015
Posts: 633

Not sure whether the XPath position() function is supported by the Mapping node, and useful for this purpose?
Back to top
View user's profile Send private message
mpong
PostPosted: Mon Apr 03, 2017 2:54 pm Post subject: Reply with quote

Centurion

Joined: 22 Jan 2010
Posts: 108

I have implemented thru custom esql but I will give it a try using XPath position() function
Back to top
View user's profile Send private message
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexWebSphere Message Broker Supportauto increment value on attribute on mapping node
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


Theme by Dustin Baccetti
Powered by phpBB 2001, 2002 phpBB Group

Copyright MQSeries.net. All rights reserved.