Re: MIDRANGE-L Digest V4 #418

Could perhaps be a logical path problem?  Is this a logical file you
are running the SQL against?  I had one situation that happened one time,
where I had a physical and logical in one library, copied them to another
library for testing, but for some strange reason the new logical in the
new library was still pointing to the old physical.  I had to log off and
back on for it to point to the "right" library.  My application was probably
somehow still using the old logical (one of those access path things, I dunno).

Regards,

Jim Langston

Me transmitte sursum, Caledoni!


Date: Fri, 27 Apr 2001 07:58:58 -0400
From: jpcarr@TREDEGAR.COM
Subject: RE: SQL error

No qualified lib used Phil.   It feels like a PTF is missing or something.

John
- ----------------------------------------
The library may be explicitly used in the sql ie
Select * from prodlib/invoice

Instead of

Select * from invoice
Could be.

Phil

- -----Original Message-----
Behalf Of jpcarr@TREDEGAR.COM


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