20 May,2013 by Jack Vamvas
UDF in DB2 . How can I view details on user defined functions?
To view user defined functions - UDF in DB2– use the SYSCAT.ROUTINES catalog view to return a full list of user defined functions including – scalar function , table function, sourced function, method and procedure.
The example query returns Functions (routinetype = ‘F’ ) and User Defined\SQL Bodied (origin in ('U', 'Q')
select r.routinename as FunctionName, r.text as FunctionBody from syscat.routines r where r.routinetype = 'F' and r.origin in ('U', 'Q')