RE: SQL query optimization

[darren@xxxxxxxxx]

> Darren ...

> Having spent most of the day yesterday trying to debug an embedded SQL
> statement, your comment about what would cause the error "query options
> file couldn't be retrieved" caught my eye.  I had the same problem
> yesterday.  What I noticed was that when I was running debug, I always
saw
> that message when I looked at the job log.  When I ran the program
without
> debug (even though my same SQL error was still there!), I didn't see the
> message in the job log.  I don't think I ever really "fixed" the problem,
> but it seemed to be related to debug, and I don't think it was hurting
> anything.  Curious if someone else knows what this message really means
...
> maybe I have another problem I don't know about!


This is the message I receive about the option file.  I don't know if this
is a standard object or not, but I submit it for your information.

 Query options retrieved file QAQQINI in library QUSRSYS.