Re: Do I need to recreate an access path?

Bill Robins wrote:

> Bruce,
>
> I appreciate what you are saying, BUT, why would re-compiling a "plain-old" CL
> program recreate the access plan?  (BTW, I had already done that).  The
> statements are run dynamically through the use of RUNSQLSTM command provided
> with SQL4/Less.

Now the answer appears.  SQL4/Less.

All bets are off.  All comments made are withdrawn.  No offense, but you 
consistently
said SQL, not SQL4/Less.

Contact the supplier of the application.
--
===========================================================
R. Bruce Hoffman, Jr. -- IBM Certified AS/400 Administrator

-- The sum of all human knowledge is a fixed constant.
    It's the population that keeps growing!


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---