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 Index » WebSphere Message Broker (ACE) Support » TDS message set issue

Post new topic  Reply to topic
 TDS message set issue « View previous topic :: View next topic » 
Author Message
Arushi
PostPosted: Fri Jan 12, 2007 3:35 am    Post subject: TDS message set issue Reply with quote

Novice

Joined: 12 Jan 2007
Posts: 21

Hi,

I am creating a message set with format as TDS. The input data that i have is delimited , seperator is $ between 2 data elements which i have mentioned in the data delimiter. How do i give the line feed seperator between 2 rows of my data?

Thanks for all the help,
Arushi
Back to top
View user's profile Send private message
kimbert
PostPosted: Fri Jan 12, 2007 3:52 am    Post subject: Reply with quote

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

The CSV sample contains some really good examples of delimited data. Just pretend that comma = $.
Back to top
View user's profile Send private message
gregop
PostPosted: Fri Jan 12, 2007 3:57 am    Post subject: Reply with quote

Voyager

Joined: 24 Nov 2006
Posts: 81

You could have a Type called ComplexType1 (or whetever you like)

This to contain your 2 elements with $ delimiter

Then create a message with one element, set its type = ComplexType1 (visible from drop down -> (..More)).

Select the message element, then properties tag, then TDS1 then set Repeating Element Delimiter = <LF>.
Back to top
View user's profile Send private message
Arushi
PostPosted: Tue Jan 16, 2007 1:20 am    Post subject: Reply with quote

Novice

Joined: 12 Jan 2007
Posts: 21

HI,

Thanks for the reply.. I tried the second option i.e created a complextype A to have the 2 elements with delimiter as $,data element seperation as 'all elements delimited'. But i was not able to define the repeating delimter to <LF> for the new message i created for this. So i created another complextype B with all elements delimited and delimiter as <LF>.This is the outer complextype.Within this i created a local element of type complextypeA and for this i set the repeating element delimier as <LF>. But only the first record is picked up.

Thanks,
Arushi.
Back to top
View user's profile Send private message
kimbert
PostPosted: Tue Jan 16, 2007 1:30 am    Post subject: Reply with quote

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

Hi Arushi,

This should work ( not tested ):

Code:

Message1 [ Type=Message1Type]
    Message1Type [ DES='All Elements Delimited'  Delimiter='UNUSED']
        Line [ Type=LineType  RepeatingElementDelimiter=<LF> maxOccurs=-1 ]
            LineType [ DES=All Elements Delimited Delimiter=$]


I was a bit puzzled by this comment:
Quote:
But i was not able to define the repeating delimter to <LF> for the new message i created for this
What was the problem?
Back to top
View user's profile Send private message
Arushi
PostPosted: Tue Jan 16, 2007 5:16 am    Post subject: Reply with quote

Novice

Joined: 12 Jan 2007
Posts: 21

Hi,

What i meant was the complextypeA is set to have delimiter as $ , so i cannot set the repeating delimiter for the same complextypeA.I had to create another one liek a wrapper for the same.

Regarding your reply - are you saying i create another complextype like a child within Message1type as Line with repeatingelementdelimiter=<LF> ?

Thanks for your help,
Arushi
Back to top
View user's profile Send private message
kimbert
PostPosted: Tue Jan 16, 2007 5:49 am    Post subject: Reply with quote

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

Quote:
Regarding your reply - are you saying i create another complextype like a child within Message1type as Line with repeatingelementdelimiter=<LF> ?
Sorry if the example was unclear. Message1 is a message based on complex type Message1Type. Line is an element based on complex type LineType.
Back to top
View user's profile Send private message
Arushi
PostPosted: Tue Jan 16, 2007 9:37 pm    Post subject: Reply with quote

Novice

Joined: 12 Jan 2007
Posts: 21

Hi,

Like you mentioned,if I define Line as a Gobalelement based on complextype LineType,the properties we can set for this are 'Tag' and 'Data Pattern' only.If i create another complextype Detail under that a local element Data then i can see the RepeatingElementDelimiter.
Also how are Message1 and Line related in your case? Sorry for troubling again.

Thanks a lot,
Arushi
Back to top
View user's profile Send private message
javaforvivek
PostPosted: Wed Jan 17, 2007 1:57 am    Post subject: Reply with quote

Master

Joined: 14 Jun 2002
Posts: 282
Location: Pune,India

Can you post a sample message for better understanding?
_________________
Vivek
------------------------------------------------------
...when you have eliminated the impossible, whatever remains, however improbable, must be the truth.
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
kimbert
PostPosted: Wed Jan 17, 2007 2:22 am    Post subject: Reply with quote

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

Hi Arushi,

Line is a member of ComplexType1 ( so it is a child of Message1 ).

You are selecting the wrong item in the Outline view. Repeating Element Delimiter does not appear as a property of a global element. It is a property of a local element or an element reference. If you select Line under the 'Elements and Attributes' subtree, it will not have a Repeating Element Delimiter. If you select it under 'Messages' or 'Types' it will.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » TDS message set issue
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.