RE: RPG SQL (SQL Syntax?)

["Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>]

>I would of thought since UCASE is a SQL function it would be efficient 

I'm sure it does an _extremely_ efficient job of upper-casing the data.
The problem is that it still has to do it to every row. 10 million of
anything is a measurable event. <G>

However, what's worse is that since you're comparing the result of a
function to a constant there's no index that can help you. 

For the shared weight indexes look at changing the "sort sequence" of
your sql session attributes to *LANGIDSHR which results in a shared
weight index between upper and lower case -- that is a case insensitive
search. Then you could drop the UCASE() function and simply do "Where
PADR1 LIKE '9999 GROVE AVENUE%'..." 

-Walden


------------
Walden H Leverich III
Tech Software
(516) 627-3800 x11
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)