Re: Default library on creating UDFT Function

Unfortunately - the answer is (as so often in IT): It depends!

If you have set a CURRENT SCHEMA before running the statement, it will be created there. 

If your script runs with RUNSQLSTM and you have set the DFTRDBCOL parameter - it's created there. 

If you work with NAMING = *SYS and the function already exists anywhere in the library list - it's re-created there. 

Otherwise it will most likely created in QGPL. 

You can find out, where your function exists, by querying the SYSFUNCS or SYSROUTINES catalog tables/views.

HTH
Daniel



> Am 15.02.2026 um 15:38 schrieb Giovanni Arturi via RPG400-L <[email protected]>:
> 
> Hi all
> 
> 
> 
> If i run "Create or replace Function MyProc", in wich library the function
> is created ??
> 
> 
> 
> If i know a function UDFT name, how can search in which library is located ?
> 
> 
> 
> Thanks
> 
> --
> 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: [email protected]
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
> 
> Please contact [email protected] for any subscription related questions.
> 
-- 
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: [email protected]
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact [email protected] for any subscription related questions.