Re: Do I need to recreate an access path?

[Bill Robins <brobins@xxxxxxxxxxxxx>]

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.

Further reading of the CPF message says that the plan is being rebuilt because
of ....  So, if it is rebuilt, why does it need to rebuild it EVERY time?

If you would like, we can take this off-line to better discuss this.

Bill

> So, I repeat....
>
> The system is normally defaulted to 65535 (or something).  Chances are the 
>program
> was compiled while the CCSID was that default value, or some other and you 
>have (or
> someone) has changed everything to 37.  So... recompile.  The access plan is 
>built
> for static SQL during the compile.
>
> Remember, Access Plan not Access Path.
>
>

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