See response to SELECT SQL - Use of a Logical Use SQL to define indexes (probably better performance) and avoid use of Select/Omit logicals. There is not enough information given to give you a good answer. The Value "X" is probably not unique enough to narrow the data down.
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
Query Optimizer - logical file select/omit
Collapse
X
-
Query Optimizer - logical file select/omit
Why won't the Query Optimizer use an existing logical file that has keys and select/omit criteria that match an SQL Select statement? Viewing the debug messages seems to point to the select/omit as the problem. Can the Where clause be changed so the Optimizer will be "influenced" to use the logical file. The statement "select * from fileA where status<>'X' order by key1" won't use logical file fileA1 that has the following DDS definition. A R FORMATA PFILE(FILEA) A K KEY1 A S STATUS COMP(NE 'X')
Comment