Re: SQL query results in CPI432F

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Dennis,

<QUOTE/>
> the value of the right side of the expression (:COMP) should be equal or
less in length to the one of the left side (TCER). If not, a
> table scan would ensue.
</QUOTE>

Whew!! I knew I had read that somewhere!! After days (not really) of digging
my old ref files, I found that info in an old  Centerfield newsletter. Check
here:

http://www.centerfieldtechnology.com/publications/archive/December%202006.pdf

Elvis (Budimlic) if you are reading this, What happened to the newsletter?
We need fresh issues!! :-)

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Mon, Feb 1, 2010 at 12:56 PM, Dennis Lovelady <iseries@xxxxxxxxxxxx>wrote:

> > once read about being sure that in a WHERE clause as in, say, WHERE
> > tcer =
> > :comp, the value of the right side of the expression (:COMP) should be
> > equal
> > or less in length to the one of the left side (TCER). If not, a table
> > scan
> > would ensue.
>
> Interesting.  But in this case, :COMP was of the same length (3, fixed) as
> the table column.  I'll have to read up on what you reported; sounds
> interesting.
>
> Dennis Lovelady
> http://www.linkedin.com/in/dennislovelady
> --
> "The most dangerous thing in the world is to leap a chasm in two jumps."
>        -- David Lloyd George
>
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.