RE: JDBC and SQL Performance Under V5R3

[CWilt@xxxxxxxxxxxx]

You're correct, sorry about that.

How about doing a:

set option srtseq = *LANGIDSHR


This way a where name = 'charles wilt'

will find:
'Charles Wilt'
'charles wilt'
'CHARLES WILT'




Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: Raul Jager [mailto:raul@xxxxxxxxxx]
> Sent: Thursday, November 04, 2004 10:08 AM
> To: Java Programming on and around the iSeries / AS400
> Subject: Re: JDBC and SQL Performance Under V5R3
> 
> 
> To many things that don't belong will be selected.
> ______________________________________________________
> El Thursday 04 November 2004 10:43, CWilt@xxxxxxxxxxxx escribió:
> > Nigel,
> > 
> > Have you tried using:
> > 
> > where fieldname between 'value' and 'VALUE' 
> > 
> > to handle the case insensitive search?
> > 
> > 
> > Now why exactly to you need LTRIM and RTRIM?  Do you 
> actually have a field
> > with '    some data    '?
> <SNIP> 
> 
> 
> --
> This is the Java Programming on and around the iSeries / 
> AS400 (JAVA400-L) mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>