Sql – How to display source of DB2 SQL UDF


Is there any way to see SQL UDF body in DB2 control center?

Best Solution

-- To get the text of UDF
select r.routinename as FunctionName, r.text as FunctionBody
from syscat.routines r
where r.routinetype = 'F' -- Function
and r.origin in ('U', 'Q') -- User-defined sourced or query-based