SELECT R.ROUTINESCHEMA AS SCHEMA_NAME
,      R.ROUTINENAME AS PROCEDURE_NAME
,      BSCHEMA AS REF_OBJECT_SCHEMA
,      BNAME AS REF_OBJECT_NAME
,      CASE BTYPE
            WHEN 'A' THEN 'Table alias'
            WHEN 'B' THEN 'Trigger'
            WHEN 'F' THEN 'Routine'
            WHEN 'G' THEN 'Global temporary table'
            WHEN 'H' THEN 'Hierarchy table'
            WHEN 'K' THEN 'Package'
            WHEN 'L' THEN 'Detached table'
            WHEN 'N' THEN 'Nickname'
            WHEN 'O' THEN 'Privilege dependency'
            WHEN 'Q' THEN 'Sequence'
            WHEN 'R' THEN 'User-defined data type'
            WHEN 'S' THEN 'Materialized query table'
            WHEN 'T' THEN 'Table'
            WHEN 'U' THEN 'Typed table'
            WHEN 'V' THEN 'View'
            WHEN 'W' THEN 'Typed View'
            WHEN 'X' THEN 'Index extension'
            WHEN 'Z' THEN 'XSR object'
            WHEN 'Q' THEN 'Sequence alias'
            WHEN 'U' THEN 'Module alias'
            WHEN 'V' THEN 'Global variable'
            WHEN '*' THEN 'Anchored to the row of a base table'
            END AS REF_OBJECT_TYPE
  FROM SYSCAT.ROUTINEDEP RD
       JOIN SYSCAT.ROUTINES R
         ON RD.ROUTINESCHEMA = R.ROUTINESCHEMA
        AND RD.SPECIFICNAME = R.SPECIFICNAME
 WHERE R.ROUTINETYPE = 'P'
       AND R.ROUTINESCHEMA NOT LIKE 'SYS%'
       --AND R.ROUTINESCHEMA = 'SCHEMA_NAME' -- PUT SCHEMA NAME HERE
       --AND R.ROUTINENAME = 'PROCEDURE_NAME' -- PUT PROCEDURE NAME HERE
 ORDER BY SCHEMA_NAME
 ,        PROCEDURE_NAME;