|   | 
	 
  
    | 
RSS Feed - WebSphere MQ Support
 | 
RSS Feed - Message Broker Support
 |   
 
  
	     | 
	 | 
   
 
  
	|  Need help XML to XML!!! | 
	« View previous topic :: View next topic »  | 
   
  
  	
	  
		
		
		  | Author | 
		  Message
		 |  
		
		  | MQTORTOISE | 
		  
		    
			  
				 Posted: Tue Dec 24, 2002 12:45 pm    Post subject: Need help XML to XML!!! | 
				     | 
			   
			 
		   | 
		 
		
		    Novice
 
 Joined: 24 Dec 2002 Posts: 15
  
  | 
		  
		    
			  
				Hi,Pls can anybody help me out in XML inbound to XML outbound msgflows sample code...
 
Thanks,
 
MQTortoise..   | 
			   
			 
		   | 
		 
		
		  | Back to top | 
		  
		  	
		   | 
		 
		
		    | 
		 
		
		  | kirani | 
		  
		    
			  
				 Posted: Thu Dec 26, 2002 10:05 am    Post subject:  | 
				     | 
			   
			 
		   | 
		 
		
		   Jedi Knight
 
 Joined: 05 Sep 2001 Posts: 3779 Location: Torrance, CA, USA 
  | 
		  
		    
			  
				Let's say you are getting following input message on the queue:
 
<Data>
 
<FirstName>ABC</FirstName>
 
<LastName>XYZ</LastName>
 
<SSN>000-00-0000</SSN>
 
</Data>
 
and you want to transform it into following format:
 
<Student>
 
<Name>XYZ,ABC</Name>
 
<SSN>000-00-0000</SSN>
 
</Student>
 
 
First read your input message as XML using your MQInput node. In a Compute node select "Copy Message Headers[/b] and write following ESQL code, which will transofmr the message:
 
   
	| Code: | 
   
  
	
 
SET OutputRoot.Student.Name = InputRoot.XML.Data.LastName || ', ' || InputRoot.XML.Data.FirstName;
 
SET OutputRoot.Student.SSN = InputRoot.XML.Data.SSN;
 
 | 
   
 
 
 
Please go thru following redbooks:
 
SG246509 - WebSphere MQ IntegratorDeployment and Migration - http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg246509.pdf 
 
SG246579 - Developing Solutions in WebSphere MQ Integrator - 
 
http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg246579.pdf _________________ 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 | 
		  
		  	
		   | 
		 
		
		    | 
		 
		
		  | MQTORTOISE | 
		  
		    
			  
				 Posted: Thu Dec 26, 2002 1:45 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		 
		
		    Novice
 
 Joined: 24 Dec 2002 Posts: 15
  
  | 
		  
		    
			  
				Thanks alot KIRAN and I implemented the same code it works fine...
 
Thanks for your time..
 
MQTortoise... | 
			   
			 
		   | 
		 
		
		  | 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
  | 
  		 
	   
	 | 
   
 
  	 | 
	  |