| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| All elements delimited ,some elements fixed lent & other |
« View previous topic :: View next topic » |
| Author |
Message
|
| itmen2k |
 Posted: Fri Feb 28, 2003 10:39 am Post subject: All elements delimited ,some elements fixed lent & other |
 |
|
Newbie
Joined: 16 Sep 2002
Posts: 5
|
I need to develop an MRM MessageSet that should accept
All elements delimited
Some of the elements I need to specify length
Some elements I can't specify because It may shrink and grows.
I tried this in MRM with
Order set, All Elements delimited and with lenght.
Every things works fine but it is ignoring the length specified on each element. I tried to pad with SPACE or '0'. MQSI ignore this.
---------------
INSTID002,CUSIP,20011117093047,,USD,1111,BID,01234.01234,2345.2345,,1234.1234
INSTID003,CUSIP,20011217093047,,USD,1111,BID,0345.0345,2345.2345
---------------
In the above output, before USD ,, it is suppose to pad 5 space.
Is it possible to do this in MRM?
Should I use NEON for this?
Can some help me. |
|
| Back to top |
|
 |
| kirani |
| Posted: Sun Mar 02, 2003 8:54 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Try using a combination of All Elements Delimited and Variable Elements Delimited.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| itmen2k |
| Posted: Tue Mar 04, 2003 12:07 pm Post subject: Dosen't work. |
|
|
Newbie
Joined: 16 Sep 2002
Posts: 5
|
| kirani wrote: |
| Try using a combination of All Elements Delimited and Variable Elements Delimited. |
I tried, this time its ignoring the commas(delimiter) but it took length.
All elemnts delimited
INSTID001,CUSIP,20011217093047,,USD,1111,BID,01234.01234,2345.2345,1234.1234
Variable Length elemnts delimited
INSTID001 CUSIP 20011217093047 USD1111BID012
34.0123400000000002345.23450000000000001234.1234000000000000
Is there any other ways? |
|
| Back to top |
|
|
| kirani |
| Posted: Tue Mar 04, 2003 9:25 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
I know I have done this before, but I don't remember it right now.
I will get back to you on this one.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| itmen2k |
| Posted: Thu Mar 06, 2003 8:29 am Post subject: |
|
|
Newbie
Joined: 16 Sep 2002
Posts: 5
|
| kirani wrote: |
I know I have done this before, but I don't remember it right now.
I will get back to you on this one. |
PLEASE ITS VERY INDEED.
Thx in adv. |
|
| Back to top |
|
|
| kirani |
| Posted: Thu Mar 06, 2003 6:33 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Here you go .... Let's say you have 5 elements.
F1,F2,F3,F4,F5
Here,
F4 and F5 have fixed length and , is your delimiter
First, create a compound type LEN_FIELD_TYPE and set following properties,
Type Composition: Ordered Set
Type Content: Closed
TDS Properties:
Data Element Separation: Variable Length Elements Delimited
Delimiter: ,
Add F4 and F5 to this compound type and set element level properties (length, etc).
Create an element of LEN_FIELD_TYPE, let's call it LEN_FIELD in our example.
Now create another compound type FIELD_TYPE.
Type Composition: Ordered Set
Type Content: Closed
TDS Properties:
Data Element Separation: All Elements Delimited
Delimiter: ,
Add F1, F2, F3 and LEN_FIELD into this compound type and then reorder them.
Create a messsage of of this type (FIELD_TYPE), write some ESQL code to assign value to these elements. If you don't get , in between then try setting Group Terminator property.
This should give you desired output.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| 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
|
|
|
|
