Has anyone ever identified a process to handle either RSTLIB or CRTDUPOBJ for cross-library logicals: those pesky logical files that join physical files in two different libraries (they can also be created as SQL VIEWs these days).

The problem is simple.  I can create a logical ABC1/LF over ABC1/PF and ABC2/PF.  But if I save and restore those libraries to a different name (say XYZ1 and XYZ2), I end up with a "broken" logical.  XYZ1/LF ends up being created over XYZ1/PF and ABC2/PF.   The same happens if I try to do a CRTDUPOBJ of ABC1/LF to XYZ1/LF.

I have found no way short of recreating the logical file with CRTLF (or RUNSQLSTM for a VIEW) to link the logical correctly to both physicals.

This has been a problem for 30 years, which is why I've since avoided them like the plague.  But I have a few of them I'm dealing with right now and they're quite annoying, and I was hoping something had changed over the years.  :)


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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

This mailing list archive is Copyright 1997-2022 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.