| Author |
Message
|
| lung |
 Posted: Sun Oct 06, 2002 9:47 pm Post subject: XML to MRM-CWF (hex, packed) |
 |
|
Master
Joined: 27 Aug 2002
Posts: 291
Location: Malaysia
|
I'm having problems trying to convert from XML to MRM-CWF in hex-packed format. What should I set in the 'physical type' field of my CWF tab? I tried Integer and Packed Decimal but I'm not getting the results I want...
Let's say my input is '1234', and I want my output to be x'1234'...
Instead, I'm getting values like x'4F2301' (packed decimal) and 'd204' (integer)...
Any help? Thanks. 
_________________
lung |
|
| Back to top |
|
 |
| kirani |
| Posted: Mon Oct 07, 2002 8:03 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Lung,
For Packed Decimal your MRM Physical Type should be set to Packed Decimal. Make sure you are doing the Data Conversion by changing CCSID & Encoding in your Compute node.
_________________
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 |
|
|
| lung |
| Posted: Mon Oct 07, 2002 5:05 pm Post subject: |
|
|
Master
Joined: 27 Aug 2002
Posts: 291
Location: Malaysia
|
Kiran,
I think I got what I want if I set to packed decimal, but the output comes out in a different manner -> x'4F230100'... I want it to be -> x'0001234F' (reverse order?)... How can I solve this?
And how do I do the data conversion in my compute node? What should I change my CCSID to and what encoding?
Thanks!
_________________
lung |
|
| Back to top |
|
|
| kirani |
| Posted: Mon Oct 07, 2002 6:57 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Lung,
How are you verifying these HEX values?
Depending on the platform to which you are sending message you should set values for Encoding and CCSID in your compute node. For example, if you are sending message to OS/390 you should set these values to 785 and 500 respectively.
_________________
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 |
|
|
| lung |
| Posted: Tue Oct 08, 2002 5:06 pm Post subject: |
|
|
Master
Joined: 27 Aug 2002
Posts: 291
Location: Malaysia
|
I'm quite embarassed to ask this, actually... But can I ask you to post some sample ESQL codings here hehe
Also, where did you get the encoding and ccsid values (785 & 500) from? It'll be very handy to have a table of these values somewhere...
Thanks lots!
_________________
lung |
|
| Back to top |
|
|
| kirani |
| Posted: Wed Oct 09, 2002 7:39 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Lung,
You could use similar code to change CCSID and encoding values using Compute node,
| Code: |
SET OutputRoot.MQMD.CodedCharSetId = 500;
SET OutputRoot.MQMD.Encoding = 785;
|
I'd put a message on M/F queue and then looked into MQMD header to get these values. I am sure there is a beter way.
_________________
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 |
|
|
| lung |
| Posted: Wed Oct 09, 2002 10:23 pm Post subject: |
|
|
Master
Joined: 27 Aug 2002
Posts: 291
Location: Malaysia
|
M/F?
_________________
lung |
|
| Back to top |
|
|
| lung |
| Posted: Thu Oct 17, 2002 7:40 pm Post subject: |
|
|
Master
Joined: 27 Aug 2002
Posts: 291
Location: Malaysia
|
What if I do not want the sign byte to be included in my output message? Like I'm getting x'0012344F' (4F being the sign byte) but what I really want is just x'001234'.
I defined my element as DECIMAL and type to Packed Decimal.
Thanks!
_________________
lung |
|
| Back to top |
|
|
| kirani |
| Posted: Thu Oct 17, 2002 9:16 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Lung,
If you don't want singed byte to be included in your data then define your field as unsinged into MRM.
_________________
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 |
|
|
| lung |
| Posted: Sun Oct 20, 2002 5:28 pm Post subject: |
|
|
Master
Joined: 27 Aug 2002
Posts: 291
Location: Malaysia
|
Kiran,
How do I define my field as unsigned into the MRM? I put No into the Signed property of my CWF tab of my element, but output is still coming out with the sign bit -> x'0012344F'... If I put Yes into the Signed property, it will give me -> x'0012344C'
How can I get my output as -> x'00001234'? Thanks!
Btw, my element type is 'Decimal' and physical type is 'Packed Decimal'...
_________________
lung |
|
| Back to top |
|
|
| kirani |
| Posted: Sun Oct 20, 2002 8:39 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Lung,
Try defining your element type as Float instead.
Does it matter what hex value (F, C or D) you get in data as long as the number is correct? Try running your destination program on this data and see if it is accepting it or not. I think you are getting correct values.
_________________
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 |
|
|
| lung |
| Posted: Sun Oct 20, 2002 9:34 pm Post subject: |
|
|
Master
Joined: 27 Aug 2002
Posts: 291
Location: Malaysia
|
Kiran,
The sign byte is still there even if I define it as 'Float'.
I cannot test the destination program because it's being developed by another party. They've requested to omit the sign byte...
I'll check with them. Thanks!
_________________
lung |
|
| Back to top |
|
|
| kirani |
| Posted: Mon Oct 21, 2002 6:21 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Lung,
What is your PIC clause (COBOL datatype) for this field?
_________________
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 |
|
|
| lung |
| Posted: Mon Oct 21, 2002 9:46 pm Post subject: |
|
|
Master
Joined: 27 Aug 2002
Posts: 291
Location: Malaysia
|
Thanks, Kiran. PIC clause is PIC9 COMP-3. I've tested this in COBOL and it does produce the sign bit.
So one problem solved, but there's still the problem pertaining to the PROPAGATE function (the other thread)... Really hope you can help me on that one, Kiran.
Thanks lots!  [/b]
_________________
lung |
|
| Back to top |
|
|
| dkesel |
| Posted: Mon Jun 02, 2003 1:15 pm Post subject: RE: Post subject: XML to MRM-CWF (hex, packed) |
|
|
Newbie
Joined: 08 Nov 2002
Posts: 4
|
Hi Lung,
How did you get your sign byte moved around to the end?? I'm trying everything I can think of and my sign is still at the front...
I see:
0C0500
I want:
00050C
Thank you so much!
Donna |
|
| Back to top |
|
|
|
|
