| Author | 
		  Message | 
  		
  		
		     Topic: ESQL INSERT .. SELECT | 
  		
  		
		  br_other
  
	  	  Replies: 7 Views: 15466
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Fri May 07, 2010 12:02 am   Subject: ESQL INSERT .. SELECT | 
  		
  		
		  | Well, guys, I understand the limitations of the PASSTHRU, but this does not answer my original question: Is there any possibility to store multiple rows in the same time, instead calling INSERT for ev ... | 
  		
  		
		     Topic: ESQL INSERT .. SELECT | 
  		
  		
		  br_other
  
	  	  Replies: 7 Views: 15466
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Thu May 06, 2010 6:00 am   Subject: ESQL INSERT .. SELECT | 
  		
  		
		  Hi people,
 
 I did workaround with: 
 
 FOR XMLItem AS Environment.Variables.SELECT_RES[] DO
 ..
 END FOR;
 
 but it's a sloppy solution and it's OK if there are couple of items to insert. 
  ... | 
  		
  		
		     Topic: ESQL INSERT .. SELECT | 
  		
  		
		  br_other
  
	  	  Replies: 7 Views: 15466
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Wed May 05, 2010 5:30 am   Subject: ESQL INSERT .. SELECT | 
  		
  		
		  Dear friends,
 
 I have the following problem and I hope that some of you with more experience will help me.
 
 I'm trying to insert data in a table with ESQL into oracle table as the data is taken fr ... | 
  		
  		
		     Topic: WMB - Namespace minor change | 
  		
  		
		  br_other
  
	  	  Replies: 5 Views: 3678
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Tue Mar 23, 2010 6:03 am   Subject: WMB - Namespace minor change | 
  		
  		
		  Thank you for the swift response guys.
 
 That solve the issue. 
 Also I did adapt the code of [url=http://www.mqseries.net/phpBB2/viewtopic.php?t=25039]robgfrk to change the ns of the fileds as well. ... | 
  		
  		
		     Topic: WMB - Namespace minor change | 
  		
  		
		  br_other
  
	  	  Replies: 5 Views: 3678
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Tue Mar 23, 2010 2:45 am   Subject: WMB - Namespace minor change | 
  		
  		
		  Hello everyone.
 
 As I already wrote in my previous post, I'm new in WBM, therefore I'll appreciate if you give ma hand regarding the issue I have.
 
 My message contain the following contain data wh ... | 
  		
  		
		     Topic: WBM - Set value of MQMD.ApplIdentityData | 
  		
  		
		  br_other
  
	  	  Replies: 3 Views: 5353
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Wed Mar 17, 2010 5:29 am   Subject: WBM - Set value of MQMD.ApplIdentityData | 
  		
  		
		  Thank you for the swift replay!
 
 The seetings in the MQOuput are as it follows (Advanced tab)
 
 Message Cotext: Set All
 Destination mode: Queue Name
 Transation mode: No
 Persistance mode: Yes
 Ne ... | 
  		
  		
		     Topic: WBM - Set value of MQMD.ApplIdentityData | 
  		
  		
		  br_other
  
	  	  Replies: 3 Views: 5353
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Wed Mar 17, 2010 5:06 am   Subject: WBM - Set value of MQMD.ApplIdentityData | 
  		
  		
		  Hello all.
 
 I'm brand new in MB, therfore I need some help.
 
 The scenario is as it follows:
 SOAP Input --> Trace --> MQHeader Node --> Compute --> Trace --> MQOutput
 
 In the comp ... |