Re: Views & *LIBL

Create a view (LF) with the desired name in each library where the target table (PF) exists, pointing at the PF in the same library.

Then, when anyone runs a query naming that view name (unqualified),  the system will use the *LIBL and you should get the desired result.

On Friday, December 20, 2024 at 11:51:19 AM EST, Justin Taylor <jtaylor.0ab@xxxxxxxxx> wrote:

When I create a view using this statement:
select *
  from Table_Name;

It appears that IBMi resolves the unqualified reference and the view saves the qualified reference, like:
select *
  from Schema_At_Create_Time.Table_Name;

Is that behavior mandatory, or is there a way for the view to resolve the
references when the view is actually queried?