RE: RPG-SQL error

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

Doesn't SQL create an access plan which is stored somewhere (package)? If
trying to run against a different file or after restore, the access plan
must be rebuilt by SQL before the program can run. I'm not sure where these
plans are stored or how one can force them to be rebuilt.

hth,
Eric DeLong

-----Original Message-----
From: jpcarr@TREDEGAR.COM [mailto:jpcarr@TREDEGAR.COM]
Sent: Friday, April 27, 2001 7:02 AM
To: RPG400-L@midrange.com
Subject: RPG-SQL error




Hey guys

Has anyone one had this situation?

SQL RPG program,   Compiled,   Everything works ok.

When run against a different Library(same file name)  or Restored and run
against a file and we get no results.


So problems when restoring RPGSQL programs or Running against same file
different library.

Any thing ring a bell??

John Carr


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

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