|
>Ucase(Field1) like '%MOR%' or UCASE(Field2) like '%MOR%' or UCASE(Field3) >like '%MOR%' Actually, that will perform like a pig. You're forcing the system to perform the UCASE() function on each of those fields for each row in the table. Changing the SRTSEQ on the job to LANDIDSHR should result in a case-insensitive comparison for everything. Also, if this is more than a one-off type query, you may want to look at the full-text indexing features of DB2400. I've not used them on iSeries, but I've used FT on SQLServer and it screams compared to a %xxx% search. I imagine the DB2 capabilities are similar. -Walden ------------ Walden H Leverich III President & CEO 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.)
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
