| Author | 
		  Message
		 | 
		
		  | hornbeam123 | 
		  
		    
			  
				 Posted: Wed Jun 07, 2006 4:58 am    Post subject: mq report options available with esql?? | 
				     | 
			   
			 
		   | 
		
		
		   Centurion
 
 Joined: 01 Nov 2003 Posts: 101
  
  | 
		  
		    
			  
				i want to set mqmd - cod report options in a compute node with esql. The message is put to a queue with MQOutput. The consuming application will generate a cod...
 
 
I know you can set replytoq and qmgr fields but nothing in wbimb 5 esql manual about setting mqmd.report.
 
 
Can this be done? | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | jefflowrey | 
		  
		    
			  
				 Posted: Wed Jun 07, 2006 5:16 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Grand Poobah
 
 Joined: 16 Oct 2002 Posts: 19981
  
  | 
		  
		    
			  
				Yes. _________________ I am *not* the model of the modern major general. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | hornbeam123 | 
		  
		    
			  
				 Posted: Wed Jun 07, 2006 6:08 am    Post subject: mq report options available with esql?? | 
				     | 
			   
			 
		   | 
		
		
		   Centurion
 
 Joined: 01 Nov 2003 Posts: 101
  
  | 
		  
		    
			  
				| Jeff but how? Where's it documented? | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | JT | 
		  
		    
			  
				 Posted: Wed Jun 07, 2006 6:14 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Padawan
 
 Joined: 27 Mar 2003 Posts: 1564 Location: Hartford, CT. 
  | 
		  
		    
			  
				
   
	| Code: | 
   
  
	| SET OutputRoot.MQMD.Report = MQRO_COD_WITH_DATA; | 
   
 
 | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | jefflowrey | 
		  
		    
			  
				 Posted: Wed Jun 07, 2006 6:15 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Grand Poobah
 
 Joined: 16 Oct 2002 Posts: 19981
  
  | 
		  
		    
			  
				What, exactly, have you tried? _________________ I am *not* the model of the modern major general. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | fschofer | 
		  
		    
			  
				 Posted: Wed Jun 07, 2006 6:28 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Knight
 
 Joined: 02 Jul 2001 Posts: 524 Location: Mainz, Germany 
  | 
		  
		    
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | hornbeam123 | 
		  
		    
			  
				 Posted: Thu Jun 08, 2006 8:29 am    Post subject: mq report options available with esql?? | 
				     | 
			   
			 
		   | 
		
		
		   Centurion
 
 Joined: 01 Nov 2003 Posts: 101
  
  | 
		  
		    
			  
				i have my answers so now i shall code and test.
 
 
thanks everybody.
 
 
for ibm a para in the wbimb esql manual to one confirm that mq report options can be set and how to code in esql would save such questions.
 
   | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | wschutz | 
		  
		    
			  
				 Posted: Thu Jun 08, 2006 8:38 am    Post subject: Re: mq report options available with esql?? | 
				     | 
			   
			 
		   | 
		
		
		    Jedi Knight
 
 Joined: 02 Jun 2005 Posts: 3316 Location: IBM (retired) 
  | 
		  
		    
			  
				
   
	| hornbeam123 wrote: | 
   
  
	i have my answers so now i shall code and test.
 
 
thanks everybody.
 
 
for ibm a para in the wbimb esql manual to one confirm that mq report options can be set and how to code in esql would save such questions.
 
   | 
   
 
Every page in the Infocenter has a "feedback" link.  The Info developers want to hear from you on how the documenation can be improved.  Thanks    _________________ -wayne | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | jefflowrey | 
		  
		    
			  
				 Posted: Thu Jun 08, 2006 8:47 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Grand Poobah
 
 Joined: 16 Oct 2002 Posts: 19981
  
  | 
		  
		    
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | hornbeam123 | 
		  
		    
			  
				 Posted: Fri Jun 09, 2006 2:57 am    Post subject: mq report options available with esql?? | 
				     | 
			   
			 
		   | 
		
		
		   Centurion
 
 Joined: 01 Nov 2003 Posts: 101
  
  | 
		  
		    
			  
				For everybody's information. 
 
 
My flow is working with the following esql :-
 
 
SET OutputRoot.MQMD.ReplyToQ = 'A.REPLY.Q';
 
SET OutputRoot.MQMD.ReplyToQmgr = ' '; --blank means broker's queue manager
 
 
SET OutputRoot.MQMD.Report = MQRO_COD +
 
	                             MQRO_COPY_MSG_ID_TO_CORREL_ID; | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | 
		    
		   |