| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Creating TDS Msg set with Compund structure |
« View previous topic :: View next topic » |
| Author |
Message
|
| bableshwar81 |
 Posted: Mon Nov 24, 2003 9:59 pm Post subject: Creating TDS Msg set with Compund structure |
 |
|
Newbie
Joined: 24 Nov 2003
Posts: 4
Location: INDIA
|
hi all,
Can anyone help me out with creation of message set in TDS format.
Here's the details: I have to create the message set using input /output test data.
We have the input structure as records(01,02,03,16,99).
Records 01,99 come at the beginning and at the end respectively. there is no problem with that.
The problem is the repetition of records for 02,03 and 16. these records can occur repetitively
in the order 02 followed by 03 and 03 followed by 16. the main problem is that sometimes records 2,3, or 16
may not be present. What is the structure that we can think for this kind of scenario?
what are the parameters that we may set for this creation?
The other problem is each record has different number of fields
Can any one help me out in designing this message set.
Here's the sample test data:
03,00557846,GBP,15,000000101312500/
16,399,000000007518000,,,,,015801 20030913/
16,399,000000000769500,,,,,027201 20030913/
16,399,000000007551000,,,,,050001 20030913/
49,0,0,0/
03,00620288,GBP,15,000000066558400/
16,399,000000001107000,,,,,059101 20030906/
16,399,000000004602100,,,,,060001 20030913/
16,399,000000005336800,,,,,060201 20030913/
49,0,0,0/
03,56381008,GBP,15,000000000000000/
02,BOOTSBTC,SECUR,1,030602,0000,GBP,0/
03,00557846,GBP,15,000000111748500/
16,399,000000003469000,,,,,027201 20030913/
16,399,000000001568000,,,,,115001 20030906/
16,399,000000005399000,,,,,115001 20030913/
49,0,0,0/ |
|
| Back to top |
|
 |
| asamanta |
| Posted: Mon Nov 24, 2003 11:43 pm Post subject: |
|
|
Novice
Joined: 20 Aug 2003
Posts: 18
|
If these 02,03,16 records are having the fixed tag at the begining(i,e any fixed value for each record at the begining) then use the Data Element Seperation as Tag Delimited, where tag for each element is fixed value and will be set to the message properties. In the Type properties, please set the Length of Tag and Delimiter, i think here it is "/".
Here, record repetitions will be decided with the Tag value. Therefore, no problem for ordering of the input record.
Please let me know if you have problem.
_________
Ardh |
|
| Back to top |
|
|
| kimbert |
| Posted: Tue Nov 25, 2003 1:52 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
The 02, 03, 16 are your tags.
The ',' which follows each tag is a tag/data separator.
Each tag is identifying a line of comma-separated fields, terminated by /<CR><LF>. (<CR><LF> is a guess, actually. Use whatever line terminator is appropriate).
You should therefore model each line as a complex element (e.g. element01). Its TDS tag should be set to '01', 02' etc. Its complex type should contain one element per comma-separated field. The complex type should have TDS Data Element Separation of 'All Elements Delimited'.
Create a complex type for the message, and add all the complex elements to it, with min and maxOccurs set as shown:
MessageType
---element01 minOccurs=1, maxOccurs=1
---element02 minOccurs=0, maxOccurs=unbounded
---element03 minOccurs=0, maxOccurs=unbounded
---element16 minOccurs=0, maxOccurs=unbounded
---element99 minOccurs=1, maxOccurs=1
Hope that helps.
Tim |
|
| Back to top |
|
|
| Missam |
| Posted: Wed Nov 26, 2003 8:51 am Post subject: |
|
|
Chevalier
Joined: 16 Oct 2003
Posts: 424
|
Hi
This is a typical requirement you have.I guess you can't do it in MRM
better go for NEON Formatter.
Thanx
Sam. |
|
| Back to top |
|
|
| kimbert |
| Posted: Wed Nov 26, 2003 8:54 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| Not sure where the previous reply is coming from...I'm pretty sure it is possible to model this using the MRM, using a model similar to one I suggested earlier. |
|
| Back to top |
|
|
| bableshwar81 |
| Posted: Wed Nov 26, 2003 10:15 pm Post subject: Thanx for the help |
|
|
Newbie
Joined: 24 Nov 2003
Posts: 4
Location: INDIA
|
Hi frnds,
Thanx for your help.....It surely works in MRM....
Using Compound structures.. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
