| Author | 
		  Message | 
  		
  		
		     Topic: How to assign a SQL decimal value to an ESQL decimal | 
  		
  		
		  Yaroslav
  
	  	  Replies: 13 Views: 15009
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Wed Oct 22, 2008 11:29 pm   Subject: How to assign a SQL decimal value to an ESQL decimal | 
  		
  		
		  Hello, m.schneider!
 I think my answer is out of date for you, but it must be helpful for others.
 I had the same  error S22018 in my environment:
   OS - Windows Server 2003
   WMB 6.1
   IBM DB2 v8. ... | 
  		
  		
		     Topic: BIP2592 / S22018 - DECIMAL in German DB2 crashs with WMB | 
  		
  		
		  Yaroslav
  
	  	  Replies: 1 Views: 4607
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Wed Oct 22, 2008 11:22 pm   Subject: BIP2592 / S22018 - DECIMAL in German DB2 crashs with WMB | 
  		
  		
		  Hello, mark.luebinski!
 I think my answer is out of date for you, but it must be helpful for others.
 I had the same  error S22018 in my environment:
   OS - Windows Server 2003
   WMB 6.1
   IBM DB2  ... | 
  		
  		
		     Topic: decimal separator in db2 | 
  		
  		
		  Yaroslav
  
	  	  Replies: 1 Views: 2869
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Wed Oct 22, 2008 10:39 pm   Subject: decimal separator in db2 | 
  		
  		
		  Hello, m.schneider!
 I think this answer is out of date for you, but it must be helpful for others.
 I have the same problem in my environment:
   OS - Windows 2003
   WMB 6.1
   IBM DB2 v8.1.15 
 The ... | 
  		
  		
		     Topic: Conversion problem in database select in WMB6 | 
  		
  		
		  Yaroslav
  
	  	  Replies: 7 Views: 6991
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Thu Dec 21, 2006 12:30 am   Subject: Conversion problem in database select in WMB6 | 
  		
  		
		  Hi, Magnus_A!
 We had similar problem: If result of SELECT contained national character(local RU), then raised same exception.
 Configuration:
 - WMB 6.0.0.0 
 - WMQ 5.3 
 - DB2 for AS400(V5R3)
 After ... | 
  		
  		
		     Topic: Compiler change from v5 to v6 broker for references? | 
  		
  		
		  Yaroslav
  
	  	  Replies: 9 Views: 8171
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Fri Oct 20, 2006 10:38 am   Subject: Compiler change from v5 to v6 broker for references? | 
  		
  		
		  You can also check if FIELDNAME(reference) is NULL.
 Hi, jefflowrey!
 I am sorry    , but your advice may be used only for static reference, not for dynamic. | 
  		
  		
		     Topic: XMLNSC.Field  (fieldtypes) issue | 
  		
  		
		  Yaroslav
  
	  	  Replies: 8 Views: 9150
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Thu Oct 19, 2006 5:24 am   Subject: XMLNSC.Field  (fieldtypes) issue | 
  		
  		
		  Sorry, I only tryed  to aswer on this:Everything works as I expect, except for the fact that it will not enter the IF FIELDTYPE(Pointer) = XMLNSC.Field THEN... 
 As to Anyone heard of a reason/know wh ... | 
  		
  		
		     Topic: What happened when -- | 
  		
  		
		  Yaroslav
  
	  	  Replies: 4 Views: 4567
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Wed Oct 18, 2006 11:32 pm   Subject: What happened when -- | 
  		
  		
		  Hello, Maria_123!
 This link will assist you  understand:
 
 http://publib.boulder.ibm.com/infocenter/wmqv6/v6r0/index.jsp?topic=/com.ibm.mq.csqzal.doc/csq3j06.htm
 (Edited) | 
  		
  		
		     Topic: XMLNSC.Field  (fieldtypes) issue | 
  		
  		
		  Yaroslav
  
	  	  Replies: 8 Views: 9150
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Wed Oct 18, 2006 12:20 pm   Subject: XMLNSC.Field  (fieldtypes) issue | 
  		
  		
		  Hi, special_agent_Queue!
 As seems to me, cause of problem in that you don't differ XMLNSC.Field and XMLNSC.Folder types.
 XMLNSC.Field  -This is the specific type value for an optimized XML element c ... | 
  		
  		
		     Topic: is FETCH supported in ESQL for the SELECT against DB2 | 
  		
  		
		  Yaroslav
  
	  	  Replies: 3 Views: 5884
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Wed Oct 18, 2006 9:58 am   Subject: is FETCH supported in ESQL for the SELECT against DB2 | 
  		
  		
		  Hi, sknrt1!
 
 It's no structure like "FETCH FIRST N ROWS ONLY"  in ESQL SELECT statement.
 
 If you want to get the same effect you can use 
   PASSTHRU(<Database specific SQL>)
 or
  ... | 
  		
  		
		     Topic: How to thow exception from Java compute node in MB V6 | 
  		
  		
		  Yaroslav
  
	  	  Replies: 4 Views: 10331
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Wed Oct 11, 2006 1:06 am   Subject: How to thow exception from Java compute node in MB V6 | 
  		
  		
		  As MbUserException inherited from MbException.
 You may simple use operator "throw new MbUserException(...)" 
 in your evaluate method. | 
  		
  		
		     Topic: Calling a Java Method using ESQL | 
  		
  		
		  Yaroslav
  
	  	  Replies: 2 Views: 2748
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Thu Sep 28, 2006 3:24 am   Subject: Calling a Java Method using ESQL | 
  		
  		
		  Little addition for 2.
 Instead of 
 "C:\Documents and Settings\All Users\Application Data\IBM\MQSI\shared-classes"
 you should use
  Broker's WorkPath\shared-classes
 
 WorkPath can be reco ... | 
  		
  		
		     Topic: HTTPInput - Additional Instances | 
  		
  		
		  Yaroslav
  
	  	  Replies: 15 Views: 18062
  | 
		   Forum: WebSphere Message Broker (ACE) Support   Posted: Thu Sep 28, 2006 3:04 am   Subject: HTTPInput - Additional Instances | 
  		
  		
		  You can use command:
 mqsiservice MyBroker -r HttpListenerThreadPoolSize=60 |