Re: Views & *LIBL

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

I do not believe so.  This would be like keeping your LF's in one library
and your PFs in another and having MYLF just use the PF from whatever
library was currently in your library list.  I don't think that's going to
work.
I suppose if your view was built over a table function instead of a table
you might be able to get that to work.

On Fri, Dec 20, 2024 at 11:51 AM 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?
>
>
> Thanks
> --
> 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.