Re: SQL using access paths NOT meant for his use ...

["Simon Coulter" <shc@xxxxxxxxxxxxxxxxx>]

Hello Antonio,

You wrote:
>BUT..., some answers cautioned me ... "as far as your logicals do not
>include Select/Omit  criteria...".
>Well, YES, my logicals DO HAVE some Select/Omit conditions... So, that
>may be the reason for the problems we are getting occassionnally! We HAVE
>HAD some problems, we could not figure out, since we were not . . . . .

As far as I know the Query Optimizer does not use Select/Omit logicals
when choosing an access path.  However, there is a possibility it *MAY*
use them *IF* the WHERE clause matches the Select/Omit criteria but I
doubt it.

Run the query in debug.  If the optimizer chooses a Select/Omit logical
and as a result misses records then open an APAR with IBM because that is
not how it should work.

Regards,
Simon Coulter.
--------------------------------------------------------------------
   FlyByNight Software         AS/400 Technical Specialists
   http://www.flybynight.com.au/

   Phone: +61 3 9419 0175   Mobile: +61 0411 091 400        /"\
   Fax:   +61 3 9419 0175   mailto: shc@flybynight.com.au   \ /
                                                             X
                 ASCII Ribbon campaign against HTML E-Mail  / \
--------------------------------------------------------------------