Re: Alternatives to LIKE in SQL

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