RE: SQL error

[mandy.shaw@xxxxxxxxxxxxxx]

Has this got something to do with SQL packages (*SQLPKG)? Rings a faint
bell though I know little in this area. I am sure there's someone out there
who knows a lot!
Mandy





jpcarr@TREDEGAR.COM on 27/04/2001 12:58:58

Please respond to MIDRANGE-L@midrange.com

To:   MIDRANGE-L@midrange.com
cc:    (bcc: Mandy Shaw/Pacific/UK)
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
+---



      Regards,
      Mandy Shaw

      Notability Solutions PLC
      Kingfisher House
      Frimley Business Park
      Camberley
      Surrey
      GU16 5SG
      UK

      http://www.Notability.com
      Email: Mandy.Shaw@Notability.com

      Telephone: +44 (0)870 166 1000
      DDI: +44 870 166 1324
      Facsimile: +44 870 168 3920
      Mobile: +44 7710 447966





----------------------------------------------------------------------
----------------------------------------------------------------------
Catalyst Solutions plc.  Registered No 2918101.
Registered @ Kingfisher House, Frimley Business Park, Frimley,
Surrey. GU16 5SG   U.K.

NOTICE:
This message is intended only for the named addressee(s) and may
contain confidential and/or privileged information. If you are not the
named addressee you should not disseminate, copy or take any action
or place any reliance on it. If you have received this message in error
please notify postmaster@catalyst-solutions.com and delete the message
and any attachments accompanying it immediately.
----------------------------------------------------------------------


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