DB2 查询非法的存储过程或视图

 --存储过程：
   SELECT RTRIM(r.routineschema) || '.' || RTRIM(r.routinename) AS spname , ' ( '|| RTRIM(r.routineschema) || '.' || 'P'||SUBSTR(CHAR(r.lib_id+10000000),2)||' )'
   FROM SYSCAT.routines r WHERE r.routinetype = 'P' AND ((r.origin = 'Q' AND r.valid != 'Y')
   OR EXISTS (SELECT 1 FROM syscat.packages WHERE pkgschema = r.routineschema AND pkgname = 
   'P'||SUBSTR(CHAR(r.lib_id+10000000),2) AND valid !='Y')) ORDER BY spname;
   --视图：
   select rtrim(viewschema)|| '.' || rtrim(viewname) as viewname from syscat.views where valid = 'X' order by viewname