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 » Perform data conversion on part of the message

Post new topic  Reply to topic
 Perform data conversion on part of the message « View previous topic :: View next topic » 
Author Message
WBI_user
PostPosted: Thu Aug 16, 2007 7:50 am    Post subject: Perform data conversion on part of the message Reply with quote

Partisan

Joined: 07 Aug 2001
Posts: 386
I have a simple flow
MQINPUT - compute - MQOUTPUT

These are some ESQL statments in the compute node
CALL CopyMessageHeaders();
:
:
SET OutputRoot.XML.Customer_record.customer_name = InputRoot.MRM.customer;
SET OutputRoot.XML.Customer_record.BrokerName = BrokerName;
:
SET OutputRoot.XML.Customer_record.BLOB = MyBLOBData;

The Incoming message is from OS390 with CCSID of 37

In the output message, everything is still in EBCDIC, which is expected because I copied the message header.

We want to read the output on AIX
so I add
SET OutputRoot.MQMD.CodedCharSetId= 437;
SET OutputRoot.MQMD.Encoding = 546;

This makes the output message readable on AIX. However depending on what is in MyBLOBData, I get an error from time to time saying that it cannot convert the data. I can also understand this.

My question is how can I code my ESQL so that it will only convert the field that I want it to convert (such as customer_name and brokername) and leave the BLOB data alone ? As a matter of fact we do not want to touch the BLOB data until it finally reached the destionation and processed by the application.
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Thu Aug 16, 2007 7:55 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981
Please don't use the XML domain.

Please use XMLNS or XMLNSC.

Please consider using CDATA sections or base64 encoding on any binary data you wish to include in an otherwise TEXT based XML Document.

In other words, everything you're trying to do here is entirely non-standard and you can't rely on it working properly.
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
shalabh1976
PostPosted: Thu Aug 16, 2007 8:49 pm    Post subject: Reply with quote

Partisan

Joined: 18 Jul 2002
Posts: 381
Location: Gurgaon, India
I had once faced similar problems as you have:
The solution was in changing the encoding value in the XML declaration section:
Something like:
Code:
<?xml version="1.0" encoding="utf-8"?>

You may not want to use utf-8 but some value like ISO xxxx.
This may or may not solve your problem.
_________________
Shalabh
IBM Cert. WMB V6.0
IBM Cert. MQ V5.3 App. Prog.
IBM Cert. DB2 9 DB Associate
Back to top
View user's profile Send private message Yahoo Messenger MSN Messenger
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Perform data conversion on part of the message
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.