- --查找某个存储过程
- 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查询函数和存储过程
最新推荐文章于 2020-11-28 21:23:52 发布