Posted: Sun Jun 25, 2006 10:28 pm Post subject: how to get ccsid of th QM
Centurion
Joined: 11 Jun 2006 Posts: 114
Hi all, I need a code in ESQL which gives me the Codedcharsetid of the local Qmanager. I dont want to use MQCCSI_INHERIT since it can be resolved only at the transmission time. I want to do some thing like this
SET ENVIRONMENT.TEMP=ASBITSTREAM(OutputRoot.XML CCSID InputRoot.MQMD.CodedCharSetid)
I dont want to use InputRoot.MQMD.CodedCharSetid . Sice it will have the value sent by the other Application. I want to use the ccsid of the QueueManager where my messageflow is running. Any one help plzz
Joined: 18 Jul 2002 Posts: 381 Location: Gurgaon, India
What happens if you give this:
MQCCSI_Q_MGR
Character data in the message is in the queue manager's character set.
On the MQPUT and MQPUT1 calls, the queue manager changes this value in the MQMD that is sent with the message to the true character-set identifier of the queue manager. As a result, the value MQCCSI_Q_MGR is never returned by the MQGET call. _________________ Shalabh
IBM Cert. WMB V6.0
IBM Cert. MQ V5.3 App. Prog.
IBM Cert. DB2 9 DB Associate
Posted: Sun Jun 25, 2006 11:08 pm Post subject: ccsid
Centurion
Joined: 11 Jun 2006 Posts: 114
These are all constants which can be resolved only at the transmission time 1.e when the mesages are about to leave the flow. I cant use those constants in my esql for casting or using in ASBITSTREAM. I have already experienced this and was also discueed in previous forums
I am not sure about how you may be able to get it in ESQL or using Java API for broker. A very round about way would be to write some java code using MQ java API in a Java Compute Node that connects to the queue manager (I am not even sure this would work). Then you could do a
getCharacterSet() on the MQQueueManager object.
However i wonder why you should be needing this because atleast in all the projects I have executed we have used the CCSID s explicitly as there is not any realistic chance of the CCSID s changing.
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