Re: ANY DB2 Experts Here????
Re: ANY DB2 Experts Here????
- Subject: Re: ANY DB2 Experts Here????
- From: Sacha Mallais <email@hidden>
- Date: Tue, 22 Mar 2005 11:06:16 -0800
On Mar 22, 2005, at 10:09 am, James Cicenia wrote:
All queries that generate UPPER in them crash!
Maybe explain what this means a little better.
This is related to my other question where I was using
CaseInsensitiveLike, I got around that one
by just using a straight SQL call as I was only testing for existence.
HOWEVER, my very cool report generator that uses DTW will not work if
any of the queries create
an UPPER in the SQL. However, if I cut and paste the generated sql
from the exception it will work?!!!!
In the vague recesses of my memory, I barely recall something about the
DB2 JDBC driver not liking the UPPER function on certain data types.
IIRC, we eventually just used a collation.
Here's a link that might help:
http://www.ibm.com/developerworks/db2/library/techarticle/0203adamache/
0203adamache.html?isrc_d=99999999
sacha
--
Sacha Michel Mallais - 800 lb. gorilla
Global Village Consulting Inc.: http://www.global-village.net/
ObAd: read "Practical WebObjects" <fnord>
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden