--查找某个存储过程
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
db2查询函数和存储过程
最新推荐文章于 2022-08-24 21:56:05 发布