Re: Sql views across libraries and restoring from backup

[Peter Dow <petercdow@xxxxxxxxx>]

Hi Dean,

SQL views are not exactly the same as logical files. They are more like 
a stored SQL statement. When you open the view, that's when the SQL 
statement is performed.

> From https://www.rpgpgm.com/2015/09/build-views-and-views-of-views.html

"When you have a Logical file and you update the "parent" Physical file, 
the Logical file is also updated. If you build hundreds of Logical files 
it slows downs updates as after the Physical file is updated all of its 
Logical files have to be updated too. In my consulting days I have seen 
a Physical file with over 200 dependent Logical files.

Views are different. They are not updated when the Physical file, or DDL 
table, is updated. Only when the View is used is the data accessed from 
the file or table. This leads to one of points Paul made where I wanted 
to exclaim "Right on!". You could have many hundreds, nay thousands, of 
Views on your IBM i and they would not affect the performance of your 
server."

So when a view is restored, the SQL statement is not performed. It does 
not matter where the files are until you open the view. As long as you 
do that after all restores are completed, it will work fine.

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx
pdow@xxxxxxxxxxxxxx /


On 11/1/2021 10:33 AM, Dean Eshleman 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.