Re: Sql views across libraries and restoring from backup

I would put them in a later library so all the depended files are in place
when it goes to restore it, that will at least mitigate the issue. There
may be a situation where you'll have to make multiple restores anyway if
you have cross attached objects. It's rare that we don't have to run the
restore looking for missing objects and updating views/indices when they
exist in a crossed schema environment.

--
Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On Mon, Nov 1, 2021 at 12:33 PM Dean Eshleman <Dean.Eshleman@xxxxxxxxxxxx>
wrote:

Hi,

I was wondering if SQL views that join two files across libraries have the
same constraints as join logical files when it comes to what library they
should be in so that a restore of the view works successfully. In other
words you should place it the library that is restored last alphabetically
so that both physicals are there when it is restored. I know that an SQL
view shows up on the system as a logical file object, but I also know they
have some differences from logical files. TIA

Dean Eshleman
Software Development Architect
Everence

1110 North Main Street
PO Box 483
Goshen, IN 46527
(800) 348-7468 ext. 3528
(574) 533-9515 ext. 3528
[Join our Talent Network]<http://www.everence.com/careers>

Confidentiality Notice: This information is intended only for the
individual or entity named. If you are not the intended recipient, do not
use or disclose this information. If you received this e-mail in error,
please delete or otherwise destroy it and contact us at (800) 348-7468 so
we can take steps to avoid such transmission errors in the future. Thank
you.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com