Re: Default library on creating UDFT Function

[Stephen Landess <steve_landess@xxxxxxxxxxx>]

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 ?