![](https://img-blog.csdnimg.cn/20201014180756919.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
DB2
Edsion_军
这个作者很懒,什么都没留下…
展开
-
DB2递归查询上级或下级机构脚本
/*递归查询*/ with temptable(COMCODE,UPPERCOMCODE,Validstatus,COMLEVEL) as ( select root.COMCODE,root.UPPERCOMCODE,root.Validstatus,root.COMLEVEL from PRPDCOMPANY root where root.COMCODE='33018335' union all select s...原创 2021-01-15 14:51:46 · 364 阅读 · 2 评论 -
DB2数据库常用脚本
/查看锁表状态/ select * from sysibmadm.locks_held with ur; /解锁表/ CALL SYSPROC.ADMIN_CMD(‘force application(6750)’); 统计表的数据量: select tabname,card from syscat.tables where tabname like ‘IFRS%’ ORDER BY tabname; select * from SYSIBM.SYSCOLUMNS where TBCREATOR=‘DB2I原创 2020-12-15 17:26:28 · 619 阅读 · 0 评论