Re: UDTF over every row

[Justin Taylor <jtaylor.0ab@xxxxxxxxx>]

Perfect!  Thank you


date: Mon, 5 Feb 2024 17:52:05 +0100
> from: "Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>
> subject: RE: UDTF over every row
>
> A UDTF can only be specified within the from clause of a  SQL Statement.
> So, the only way is to join the UDTF with a table or view in the FROM
> Clause
> and then use the results.
> If information from the table (such as column values) has to be passed as
> parameter to the UDTF you have to deal with LATERAL
>
> ... something like this
> Select ODOBTX, p.*
>    From Table(Users()) u,
>         Lateral(Select *
>                   From Table(Object_Ownership(User_Profile => Odobnm)) x) p
>    Where     Odobnm not Like 'Q%'
>          and Odobnm not Like '#%'
>          and Object_Name like '%SALES%'
> ;
>
> Mit freundlichen Gr??en / Best regards
>
> Birgitta Hauser
> Modernization ? Education ? Consulting on IBM i
> Database and Software Architect
> IBM Champion since 2020
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them
> and keeping them!"
> "Train people well enough so they can leave, treat them well enough so they
> don't want to. " (Richard Branson)
> "Learning is experience ? everything else is only information!" (Albert
> Einstein)