db2查询函数和存储过程

--查找某个存储过程
 select * from syscat.procedures where procschema='PAS' and procname='sp_insert_xtrz'
--查找某个函数
select * from syscat.functions where funcschema='PAS' and funcname='sp_insert_xtrz'


--=================
--查找当前时间
--取得当前年月日：
--取得当前时分秒： 
--取得当前年月日时分秒 
--==================
SELECT current date FROM sysibm.sysdummy1 
SELECT current time FROM sysibm.sysdummy1 
SELECT current timestamp FROM sysibm.sysdummy1 

SELECT F_ISDATE(20100231) FROM sysibm.sysdummy1 
--查找试图
select * from syscat.views
select * from syscat.indexs


--转换截取--
select substr(cast(20100930 as char(100)),5,2)  from  sysibm.sysdummy1