RE: Problem with SQL/Logical file at V7R1

As a footnote, IBM has replicated the issue and is working on a fix. In
meantime, if you are at V7R1, having IGNORE_DERIVED_INDEX set to *YES in
QAQQINI does not send references to logical files to the classic query
engine (CQE) as it did back in V6R1.

At V7R1 the SQL query engine (SQE) should be able to handle Select/Omit
logical files, so they will get routed to the SQE instead of the CQE. So
IGNORE_DERIVED_INDEX *YES doesn't really do anything anymore, per the
response back on our ticket. If you want the SQE to ignore select/omit
logical files, the setting would be IGNOGRE_DERIVED_INDEX *SPARSE.

I'm not sure of the difference between that and the other workaround I was
given, of adding SERVICE_AR 2 to QAQQINI with:

INSERT into <yourlib>. QAQQINI VALUES('SERVICE_AR','2','disable LF')

but both seem to work.


Andrew&nbsp;&nbsp;Lopez
Systems Analyst



Phone:&nbsp;&nbsp;&nbsp;803-714-2037


Email: ALopez@xxxxxxxxxx
Please consider the environment before printing this e-mail.


This message and any attachments should be treated as proprietary to the sender
and confidential to the identified recipients and should not be disclosed to or
used by anyone other than the intended recipient unless pre arranged with the
sender. If you are not an addressee of this communication, have received this
e-mail by transmission error of the sender, recipient or due to another
originator by an error in transmission, you are hereby notified that any
disclosure, copying, use, distribution, or taking of any action in reliance on
the contents of this information is prohibited. In any such event, please
notify the sender immediately by contacting Spirax Sarco Inc., 803 714 2000 or
reply to this e-mail and then delete it from your system. Spirax Sarco Inc.
accepts no responsibility for software viruses and all recipients should check
for viruses before opening any attachments.