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

[Vernon Hamberg <vhamberg@xxxxxxxxx>]

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-