RE: SQL Optimizer and LF with *OMIT fields

Is it a logical file or a view?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
GKern@xxxxxxxxxxxxxxxx
Sent: Friday, February 23, 2007 3:18 PM
To: midrange-l@xxxxxxxxxxxx
Subject: SQL Optimizer and LF with *OMIT fields

A co-worker just showed me a problems she's having. She has an LF that
has 
*OMIT fields specified to reduce the size of the number of available 
entries in the file. The LF is used in an embedded ILE RPG program, that

has a "select * from my_LF where insurance_company <> nnn" statement.

In a debug session she noticed that the optimizer chose to do its own 
thing and it read over the entire physical file, and included records
that 
were supposed to be ignored (via the *OMIT) specified for the LF. 

So the program is suspect as to the integrity of what SQL will actually 
select. We have a few other programs that use this technique and to my 
knowledge haven't had any other problems of a similar nature.

So.... Is there any way to override the query optimizer so that it will 
always use the actual file/lf specified in the select statement?

Thanks!

Regards, Jerry

Gerald Kern - MIS Project Leader
Lotus Notes/Domino Administrator
IBM Certified RPG IV Developer
The Toledo Clinic, Inc.
4235 Secor Road
Toledo, OH 43623-4299
Phone 419-479-5535
gkern@xxxxxxxxxxxxxxxx


This e-mail message, including any attachments, is for the sole use of
the 
intended recipient(s) and may contain confidential and privileged 
information. Any unauthorized use, disclosure or distribution is 
prohibited. If you are not the intended recipient, please inform the 
sender by reply e-mail and destroy this and all copies of this message.