Calling UDTF passing as parameter select field of master file

Hi all

 

Suppose i have a file master item  with two fields   : code and descr 

i have an UDTF "getprice",  that have as input code (master code) and that
return price. 

as i would need to have a result sorted for price, i was asking me if it
possible to run this SQL statement

 

select * from item as i left join table(getprice(:i.code)) as p on i.code =
p.code order by p.price 

 

Thanks in advance 

-- 
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.