RE: SQL query optimization

Lisa,

I don't know if the message being thrown is a big
deal, or if it is just letting you know that there
have been no user changes made to query, but one way
to make the message go away is to create a duplicate
of QAQQINI in QSYS into QUSRSYS.

Could cause problems for you though when upgrading to
V5R1 as the V4 format is not the same as the V5
format.

Phil

PS: Joe, this is one for your upgrade incompatibility
list you spoke of over the weekend.


--- 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.
>


__________________________________________________
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com