Posted: Fri Dec 13, 2002 3:26 pm Post subject: MQMD Setting up problem
Apprentice
Joined: 11 Oct 2001 Posts: 30
I have a message comming from AS400 to MQSI on W2k.
AccountingToken is being set on AS400 to '000010000120021213'.
When it comes to W2k in queue looks like 'F0F0F0F0F1F0F0F0F0F0F2F0F0F2F1F2F1F34040404040404040404040404040'.
When in MQSI, I assign it to an Output field as :
SET "OutputRoot"."XML"."RootTagName"."FieldName" = InputRoot.MQMD.AccountingToken;
In output XML message it appears as:
<RootTagName><FieldName>160105150000009b0bc11ef450ba7443170a32eb03000000000000000000000b</FieldName></RootTagName>
I am expecting the value what was set on AS400 to MQMD.AccountingToken, any lead?
Joined: 05 Sep 2001 Posts: 3779 Location: Torrance, CA, USA
MQMD.AccountingToken is a binary field, which is 32 bytes long, hence you are seeing X'F0F0....' in your queue. If you want to get corresponding char string value for this field then use CAST .. CCSID function. Here is the sample code:
Code:
SET "OutputRoot"."XML"."RootTagName"."FieldName" = CAST (InputRoot.MQMD.AccountingToken CCSID InputRoot.Properties.CodedCharSetid);
_________________ Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
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