Re: Alternatives to LIKE in SQL

["Michael Naughton" <michael_naughton@xxxxxxxxxxxx>]

Hi Doc,

Are your programs coded in free format or fixed? If fixed, you should be
able to locate the field names in one of several fairly well-defined
places (the exception is Factor 2 for Evals, but even then you might be
able to identify a small number of possibilities, depending on your coding
style).

If you've got "free" code, then -- well, <dinosaur mode> let's just say
that's one reason I'm not a big fan of "free" </dinosaur mode> :-)

RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx> writes:
>Hey All
>
>I'm going to be doing some mass-scans of RPGLE source, and I'm trying to
>figure
>out if there's a better way than using the SQL LIKE keyword.
>
>I was thinking I'd to do Dynamic SQL that looks something like this:
>
>
>SELECT COUNT(*) FROM SRCMBR
>  WHERE SRCDTA LIKE '%<field name>%' AND
>    SUBSTR(srcdta,7,1) <> '*' 
>
>This select does two character comparasons, which can't be cheap, and the
>LIKE
>has to do a pattern match which is likewise expensive.  However, I don't
>know
>enough about SQL to do anything that would be less intensive.
>
>This is part of a set of programs that will enable me to keep track of
>various
>versions of our product at certain customer sites.  For that reason, I
>want
>this solution to be as automated as possible (otherwise, I'd wumpus up
>some
>quick and dirty programs driven through a PDM option).
>
>Any ideas?
>
>Thanks
>
>-Doc


Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@xxxxxxxxxxxx