Retrieving catalog information about user-defined functions and stored procedures

You can use this example to find packages with stored procedures that were created prior to Version 6 and then migrated to the SYSIBM.SYSROUTINES table:

SELECT SCHEMA, NAME FROM SYSIBM.SYSROUTINES
   WHERE ROUTINETYPE = 'P';

You can use this query to retrieve information about user-defined functions:

SELECT SCHEME, NAME, FUNCTION_TYPE, PARM_COUNT FROM SYSIBM.SYSROUTINES
   WHERE ROUTINETYPE='F';