| Author | 
		  Message | 
  		
  		
		     Topic: Syntax error in esql for sql queries with top, order by | 
  		
  		
		  vrboya
  
	  	  Replies: 3 Views: 3022
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Fri Jan 23, 2015 9:21 am   Subject: Syntax error in esql for sql queries with top, order by | 
  		
  		
		  Try to run the sql query use a PASSTHRU code
 
 Syntax looks something like this
 
 DECLARE cSQLQuery CHARACTER;
 SET cSQLQuery = 'select top(1) employeeId, amount ,paidamount from dbname.schema.table ... | 
  		
  		
		     Topic: Monitoring WMB | 
  		
  		
		  vrboya
  
	  	  Replies: 8 Views: 23728
  | 
		   Forum: IBM MQ Performance Monitoring   Posted: Tue Sep 24, 2013 2:23 pm   Subject: Monitoring WMB | 
  		
  		
		  Hi Guys,
 Does anybody have any idea regarding where the JIDA_Path has to be configured to message broker while configuring the OPNET monitoring tool.
 
 I tried to configure mqsistartmsqflow script f ... | 
  		
  		
		     Topic: Help needed on WMB configuration with OPNET Monitoring tool | 
  		
  		
		  vrboya
  
	  	  Replies: 6 Views: 7192
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Tue Sep 24, 2013 2:18 pm   Subject: Help needed on WMB configuration with OPNET Monitoring tool | 
  		
  		
		  | Yes, It is WMB only | 
  		
  		
		     Topic: Help needed on WMB configuration with OPNET Monitoring tool | 
  		
  		
		  vrboya
  
	  	  Replies: 6 Views: 7192
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Tue Sep 24, 2013 7:34 am   Subject: Help needed on WMB configuration with OPNET Monitoring tool | 
  		
  		
		  Opnet give graphical inferface for all JVMs. 
 we are old customer for opnet, currently we are using opnet tool for other applications. As a request from client to use opnet with MBK.
 I am wondering  ... | 
  		
  		
		     Topic: Help needed on WMB configuration with OPNET Monitoring tool | 
  		
  		
		  vrboya
  
	  	  Replies: 6 Views: 7192
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Tue Sep 24, 2013 7:05 am   Subject: Help needed on WMB configuration with OPNET Monitoring tool | 
  		
  		
		  Thank Lancelotlinc for your quick response & Information. 
 
 Opnet have lib files in lib folder, so do you want me to copy the jar file and place in /var/mqsi/shared-classes . Were exactly I need ... | 
  		
  		
		     Topic: Help needed on WMB configuration with OPNET Monitoring tool | 
  		
  		
		  vrboya
  
	  	  Replies: 6 Views: 7192
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Mon Sep 23, 2013 12:53 pm   Subject: Help needed on WMB configuration with OPNET Monitoring tool | 
  		
  		
		  Hi Guys,
 Does anybody have any idea regarding where the JIDA_Path has to be configured to message broker while configuring the OPNET monitoring tool.
 
 I tried to configure mqsistartmsqflow script f ... | 
  		
  		
		     Topic: Issue inserting Record into Database using Java compute node | 
  		
  		
		  vrboya
  
	  	  Replies: 2 Views: 3005
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Thu Aug 22, 2013 2:28 pm   Subject: Issue inserting Record into Database using Java compute node | 
  		
  		
		  Hi 
 I am trying to insert Request and Response into a table using the java compute node.
 My Flow:
 
 For saving request
 MQ Input node ---> javacompute node
 
 For Saving Response
 MQ Input node  ... |