On 11-Jun-2014 13:29 -0500, CRPence wrote:
On 11-Jun-2014 12:43 -0500, Koester, Michael wrote:
This SQL View is created from joining a physical file with a
couple other views. I verified from the joblog that the
dependent views had been successfully restored prior to the
attempt to restore the problem view. Incidentally, the other five
views (two of which join to another view) restored without
When a VIEW is created the /statement text/ is maintained in the
*FILE object and in the catalogs. When the VIEW is restored to a
new library, the qualified table-references must be updated to
reflect the new schema [library] name.
I don't know if "nonqualified" table names would need to be updated
or not, but for the most part we don't qualify in our source code. We
rely on the library list for that, and that is the case here.
This mailing list archive is Copyright 1997-2015 by MIDRANGE dot 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 here. If you have questions about this, please contact