Re: Default library on creating UDFT Function

Stephen Landess <[email protected]> Sun, 15 Feb 2026 22:16:10 +0000

Newsgroups	gmane.comp.lang.as400.rpg
Message-ID	<DS7PR19MB6325D301400511B9AF2185A8836FA@DS7PR19MB6325.namprd19.prod.outlook.com>

SELECT
  CAST(LEFT(SPECIFIC_NAME,20)     AS CHAR(20)) AS NAME
, CAST(LEFT(SPECIFIC_SCHEMA,20)   AS CHAR(20)) AS SCHEMA
, CAST(LEFT(ROUTINE_NAME,20)      AS CHAR(20)) AS ROUTINE
, CAST(LEFT(ROUTINE_SCHEMA,20)    AS CHAR(20)) AS ROUTINESCHEMA
, CAST(LEFT(EXTERNAL_NAME,30)     AS CHAR(30)) AS EXTNAME
, PARAMETER_STYLE
, DATE(RTNCREATE)                              AS DATE_CREATED

FROM QSYS2.SYSFUNCS
WHERE ROUTINE_NAME = 'YOUR UDTF NAME'

Regards,
Steve Landess
(512) 289-0387

Regards,
Steve Landess
(512) 289-0387

Gio wrote:
> Hi all
>If i know a function UDFT name, how can search in which library is located ?

-- 
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.