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

Have you verified that the problems come from records not being returned
that you expect, that are excluded by the select/omit? I thought that a
select/omit logical would be used only if it's criteria exactly matched the
WHERE or HAVING clause of an SQL statement

I've said that when a select/omit logical is used as the FROM file - then
record selection is done in the logical. This is why you're encouraged to
use physical files as FROM files, not logicals.

At 06:53 PM 7/6/02 +0200, you wrote:

-snip-

>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 aware of the problem
>until
>many days after. IF BPCS sometimes uses my logicals, which include some
>Select/Omit criteria, then I guess this COULD really produce erroneous
>results,
>and nobody would become aware of, until much later ???

-snip-