Re: SQL query optimization

The message about not being able to find the query options file is
normal.

The query options file (QAQQINI) lets you specify a few pieces of
information about how you want queries to run (e.g., optimize to show
the first n records or optimize to run the entire query, allow copies of
data to be created). In a nutshell, attributes you can set that
influence how the query optimizer does its job.

This initialization file is not required. In its absence, default values
will be used.

Gary Guthrie
Senior Technical Editor, iSeries NEWS






Lisa.Abney@sensient-tech.com wrote:
>
> 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!
>
>                     darren@dekko.com
>                     Sent by:                 To:     rpg400-l@midrange.com
>                     rpg400-l-admin@mi        cc:
>                     drange.com               Subject:     RE: SQL query 
>optimization
>
>                     02/12/2002 08:30
>                     AM
>                     Please respond to
>                     rpg400-l
>
> >'SELECT QCCAT, QCCACT FROM QACAT00   ORDER BY QCCAT '
> >The keyfield in the file is 'QCCAT'
> >Why is it not using the access path of my logical? (Mike)
>
> Mike,
>
> This is a fairly simple statement.  I'm sorry I can't offer a concrete
> solution yet.  One thing I do to troubleshoot SQL is the STRSQL.  You can
> STRDBG and then play with different interactive SQL statements to try and
> deduce what is going on.  I'm a little concerned that it said your query
> options file couldn't be retrieved, I wonder what would cause this...
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.