ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » DB2 select returns no / empty result with special characters

Post new topic  Reply to topic
 DB2 select returns no / empty result with special characters « View previous topic :: View next topic » 
Author Message
j.f.sorge
PostPosted: Wed Nov 23, 2011 4:24 am    Post subject: DB2 select returns no / empty result with special characters Reply with quote

Master

Joined: 27 Feb 2008
Posts: 218
Hello,

after migrating WMB 6.1.0.9 from Solaris to Linux environment I have problems when using ESQL SELECT statement on ODBC DB2 z/OS. When selecting data from a table which contains special characters it does not get any error message but it returns no / empty result. When setting up ODBC trace it shows the following error / warning message
Code:
[IBM][CLI Driver] CLI0002W  Data truncated. SQLSTATE=01004

but I'm not sure if this is the cause of the empty result.

Very strange is that SELECTING data from an UTF-8 DB2 LUW database returns the correct data. On our Solaris environment both UTF-8 DB2 LUW and DB z/OS works correctly, too.

I saw this Thread here but we already set all the locale values.

Does anyone have any idea which configuration has to be changed?
_________________
IBM Certified Solution Designer - WebSphere MQ V6.0
IBM Certified Solution Developer - WebSphere Message Broker V6.0
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0
Back to top
View user's profile Send private message
j.f.sorge
PostPosted: Tue Dec 13, 2011 11:36 pm    Post subject: Reply with quote

Master

Joined: 27 Feb 2008
Posts: 218
I have raised PMR 10754,031,724 in order to solve the problem and will update this thread with the information I get.
_________________
IBM Certified Solution Designer - WebSphere MQ V6.0
IBM Certified Solution Developer - WebSphere Message Broker V6.0
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » DB2 select returns no / empty result with special characters
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.