需求分析:本地化零件待办数量对应用户统计存入数据表,定时更新,使用linux的crontab定时任务来完成
1.编写存储过程
--设置指向的数据库
SET SCHEMA = DB2INST1;
--设置当前的路径
SET CURRENT PATH =
"SYSIBM","SYSFUN","SYSPROC","SYSIBMADM","DB2INST1";
--创建存储过程
CREATE PROCEDURE "DB2INST1".monitor_lingjian()
Begin
--删除本地化零件(009)相关的数据
delete from cs_coc_deal_infos where SYS_ID='009';
--插入统计的本地化零件相关的数据至cs_coc_deal_infos表中
insert into cs_coc_deal_infos(SYS_ID,DEAL_NUM,DEAL_USER)
select '009' as SYS_ID,sum(num) as DEAL_NUM,DESINGER from(
select count(*) as num,DESINGER from SOA_LPP_TM_TASK_V group by DESI