| Author | 
		  Message | 
  		
  		
		     Topic: AMQ8138    Error message on as400 in out que | 
  		
  		
		  wcrausch
  
	  	  Replies: 2 Views: 3458
  | 
		   Forum: General IBM MQ Support   Posted: Tue Sep 24, 2002 9:19 am   Subject: AMQ8138 Error message on as400 in out que | 
  		
  		
		  You have to look at the transmission queue, not the remote queue to look at messages that are outbound.
 
 Bill Rausch | 
  		
  		
		     Topic: DB2 ODBC Error SQL0514 "Cursor not in Prepared State&qu | 
  		
  		
		  wcrausch
  
	  	  Replies: 6 Views: 11587
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Thu May 23, 2002 6:56 am   Subject: DB2 ODBC Error SQL0514 "Cursor not in Prepared State&qu | 
  		
  		
		  Should I do the bind or must I? I ask because most of the time, everything works okay. It is only once in a while I have problems.
 
 Also, does it matter if it MQSi and not WMQI? | 
  		
  		
		     Topic: DB2 ODBC Error SQL0514 "Cursor not in Prepared State&qu | 
  		
  		
		  wcrausch
  
	  	  Replies: 6 Views: 11587
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Thu May 23, 2002 6:17 am   Subject: DB2 ODBC Error SQL0514 "Cursor not in Prepared State&qu | 
  		
  		
		  | What does the bind statement do? | 
  		
  		
		     Topic: DB2 ODBC Error SQL0514 "Cursor not in Prepared State&qu | 
  		
  		
		  wcrausch
  
	  	  Replies: 6 Views: 11587
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Wed May 22, 2002 12:31 pm   Subject: DB2 ODBC Error SQL0514 "Cursor not in Prepared State&qu | 
  		
  		
		  Has anyone seen the following error (Application Log): 
 
 Database error: SQL State '26501'; Native Error Code '-514'; Error Text '  
 
 I am running MQSi 2.0.2 (DB2 v7.1) on Windows NT 4 and am tryi ... | 
  		
  		
		     Topic: ODBC & Firewalls | 
  		
  		
		  wcrausch
  
	  	  Replies: 2 Views: 3965
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Tue Jan 22, 2002 3:03 pm   Subject: ODBC & Firewalls | 
  		
  		
		  Well, I have answered my own question. Looks like you need to have the following two lines added to the db2cli.ini file.
 
 [COMMON]
 QUERYTIMEOUTINTERVAL=0
 
 Bill | 
  		
  		
		     Topic: ODBC & Firewalls | 
  		
  		
		  wcrausch
  
	  	  Replies: 2 Views: 3965
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Tue Jan 22, 2002 1:57 pm   Subject: ODBC & Firewalls | 
  		
  		
		  Just to give a little more information....
 
 We can read data fine, but we can't seem to do inserts. | 
  		
  		
		     Topic: ODBC & Firewalls | 
  		
  		
		  wcrausch
  
	  	  Replies: 2 Views: 3965
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Tue Jan 22, 2002 1:26 pm   Subject: ODBC & Firewalls | 
  		
  		
		  | Has anyone had any luck doing ODBC calls wit MQSi over a firewall through the Internet? We were successful doing this all behind the firewall, but once one of the servers was changed to another in a f ... | 
  		
  		
		     Topic: SendMailPlugIn | 
  		
  		
		  wcrausch
  
	  	  Replies: 2 Views: 4499
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Tue Jan 22, 2002 1:23 pm   Subject: SendMailPlugIn | 
  		
  		
		  | It seems that the error message I get in the Application Log (NT Event Viewer) when I attempt to send an XML through a flow with a SendMailPlugIn node is the following, which doesn't show up as an err ... | 
  		
  		
		     Topic: SendMailPlugIn | 
  		
  		
		  wcrausch
  
	  	  Replies: 2 Views: 4499
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Tue Jan 22, 2002 10:16 am   Subject: SendMailPlugIn | 
  		
  		
		  Has anyone used the SendMailPlugIn on MQSi 2.0.2 on NT or Windows 2000? I have it installed, but can't seem to get it to run. Any tips on how to make that work would be appreciated.
 
 Bill | 
  		
  		
		     Topic: MQSI and JDEdwards | 
  		
  		
		  wcrausch
  
	  	  Replies: 1 Views: 4721
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Tue Nov 13, 2001 8:05 am   Subject: MQSI and JDEdwards | 
  		
  		
		  I have a number of references for JDE and MQSi. You can contact me at:
 
 billrausch@timbercreeksys.com | 
  		
  		
		     Topic: MQSi & Clusters | 
  		
  		
		  wcrausch
  
	  	  Replies: 5 Views: 8728
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Thu Sep 20, 2001 3:30 pm   Subject: MQSi & Clusters | 
  		
  		
		  Has anyone tried to implement MQSeries Clusters with MQSi 2.0.2? 
 
 I get a "completion code: 2 reason code: 2085" in the Event Viewer (Windows NT)when when I define an MQInput node that points to a  ... | 
  		
  		
		     Topic: ESQL DTD Declaration | 
  		
  		
		  wcrausch
  
	  	  Replies: 7 Views: 20629
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Tue Sep 04, 2001 12:16 pm   Subject: ESQL DTD Declaration | 
  		
  		
		  I received a note from IBM, explaining how to do this. In case anyone else has the same problem, here is the solution:
 
 SET  OutputRoot.XML.(XML.XmlDecl)='';
 SET  OutputRoot.XML.(XML.XmlDecl).(XML. ... | 
  		
  		
		     Topic: ESQL DTD Declaration | 
  		
  		
		  wcrausch
  
	  	  Replies: 7 Views: 20629
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Thu Aug 30, 2001 7:11 am   Subject: ESQL DTD Declaration | 
  		
  		
		  (I don't understand why this didn't show up in my last post....)
 
 <?xml version="1.0" encoding="utf-8"?>
 <!DOCTYPE SYSTEM "Create_NC_Customer_10.dtd">
 < ... | 
  		
  		
		     Topic: ESQL DTD Declaration | 
  		
  		
		  wcrausch
  
	  	  Replies: 7 Views: 20629
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Thu Aug 30, 2001 5:37 am   Subject: ESQL DTD Declaration | 
  		
  		
		  I usually have more XML following the DTD Decl, but I did not copy into my post.I tried that and the result is:
 
  
  
 Hello!
 
 According to the 2.0.1 documentation, my last ESQL should have been c ... | 
  		
  		
		     Topic: ESQL DTD Declaration | 
  		
  		
		  wcrausch
  
	  	  Replies: 7 Views: 20629
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Wed Aug 29, 2001 6:30 pm   Subject: ESQL DTD Declaration | 
  		
  		
		  I should also mention that I tried:
 
 SET OutputRoot.XML.(XML.XmlDecl)='';
 SET OutputRoot.XML.(XML.XmlDecl).(XML.Version)='1.0';
 SET OutputRoot.XML.(XML.XmlDecl).(XML.Encoding)='utf-8';
 SET Output ... |