|  | 
 
  
    | RSS Feed - WebSphere MQ Support | RSS Feed - Message Broker Support |  
 
  
	|    |  |  
  
	| transform CCSID from Mainframe to solaris | « View previous topic :: View next topic » |  
  	| 
		
		
		  | Author | Message |  
		  | madhu | 
			  
				|  Posted: Mon Aug 04, 2003 7:05 pm    Post subject: transform CCSID from Mainframe to solaris |   |  |  
		  | Novice
 
 
 Joined: 09 Jul 2003Posts: 22
 
 
 | 
			  
				| Hi guys, 
 need a small help.
 
 I am working on data transformation from mainframe to solaris. putting a message on to Queue in mainframe environemnt, transforming it in MQSI, then sending it to solaris system.(i.e. first queue is in mainframe and second in solaris)
 
 in MQSI, I need to change/modify the CCSID(Coded Character Set ID) that comes with mainframe message and send the modified one to solaris. I think the CCSID in mainframe will be 37.  I think I need to modify it to CCSID that is specific to solaris environment so that the Applications able to read the message in queue.
 
 How can I do that? where should I look for that ID? in Message header??
 
 pls help me.
 
 thanks
 madhu
 |  |  
		  | Back to top |  |  
		  |  |  
		  | kirani | 
			  
				|  Posted: Mon Aug 04, 2003 7:34 pm    Post subject: |   |  |  
		  | Jedi Knight
 
 
 Joined: 05 Sep 2001Posts: 3779
 Location: Torrance, CA, USA
 
 | 
			  
				| You did not tell us on which platform your broker is running? What are the contents of your message? IS it a Text message or will it also have Binary data (numeric, packed decimal, etc)? For text messages, you can do the data conversion within your client program using MQGMO_CONVERT option.
 If your data contains Binary data then you can use WMQI to convert data from one format (EBCDIC) to another (ASCII). This can be done by defining your input message into MRM. WMQI will internally convert this message into Unicode format after parsing. When writing out the message you can specify different CCSID and Encoding of different platform and WMQI will do the conversion for you. You need to use similar code for data conversion:
 
 
 
   
	| Code: |  
	| SET OutputRoot.Properties.CodedCharSetId = Solaris_CCSID;
 SET OutputRoot.Properties.Encoding = Solaris_Encoding;
 
 |  
 Hope this helps.
 _________________
 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 |  |  
		  |  |  
		  | jfluitsm | 
			  
				|  Posted: Sun Aug 10, 2003 7:28 am    Post subject: |   |  |  
		  | Disciple
 
 
 Joined: 24 Feb 2002Posts: 160
 Location: The Netherlands
 
 | 
			  
				| A better solution will be to use the convert option from MQ instead of using MQSI for CCSID and Encoding conversion. _________________
 Jan Fluitsma
 
 IBM Certified Solution Designer WebSphere MQ V6
 IBM Certified Solution Developer WebSphere Message Broker V6
 |  |  
		  | 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
 
 |  |  |  |