Re: View/UDF - What library?

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Note that this solution feels icky IMHO...

One of those "if you need that, you're doing something wrong..."

I'd maybe look at having the UDTF replicated into each library with the
view.

The PSDS would have the library in POS(81)...not sure if that's less icky
or not. :)

Charles



On Wed, Jan 8, 2025 at 2:20 PM Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

> Is there some other table in the library with the view?
>
> Can you include an f-spec for that table in the RPG program along with a
> file information data structure (INFDS)?
>
> The INFDS would give you the library name, CHAR(10), in POS(93).
>
> HTH,
> Charles
>
> On Wed, Jan 8, 2025 at 9:16 AM Justin Taylor <jtaylor.0ab@xxxxxxxxx>
> wrote:
>
> > I've got a view that calls an external user-defined function (UDF) written
> > in RPGLE. The view exists in multiple libraries, so the UDF needs to know
> > which library it is in.
> >
> > Is there a way in the DDL for the view to determine what library it is in?
> > If so, I could simply pass it to the UDF as a parameter.
> >
> > Is there a way in the UDF to determine the library of the calling view?
> >
> >
> >
> > 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.