RE: SQL query optimization

["Smith, Mike" <Mike_Smith@xxxxxxxxxxxxxxxx>]

i think you only see those messages when you debug.  you won't see any of
your 'access path selected' or temporary work file created messages either.


the ibm sql book tells you if your trying to tune your sql, to put your
program in debug to see the messages.
So, no, you didn't fix anything.   but your in the same boat as me for sure.


-----Original Message-----
From: Lisa.Abney@sensient-tech.com [mailto:Lisa.Abney@sensient-tech.com]
Sent: Tuesday, February 12, 2002 8:33 AM
To: rpg400-l@midrange.com
Subject: RE: SQL query optimization



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.