1 - Is there a copy of IM02T in your library list which would cause it to
use that instead of whatever is in CURRENT SCHEMA? Some SQL naming thing?
2 - Some weird thing where it doesn't close IM02T and uses an old open
path? Something a hack may resolve like adding FOR FETCH ONLY, or WITH NC
or some such thing?
3 - If you run it line by line are there any indications in the Messages
that something didn't quite work right? Like it never changed current
schema?

I can't think of any way to change
from IM02T
to
from current_schema.IM02T


Rob Berendt

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.