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 <rpg400-l@xxxxxxxxxxxxxxxxxx>:

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: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.