insert into del_piid (id) select first 100 piid from process_instance_b_t where state=3;
delete from scope_instance_b_t where piid in(select id from del_piid);
delete from activity_instance_b_t where piid in(select id from del_piid);
delete from est_complaint_stat where mainid in(
select mainid from complaint_link_stat l, complaint_main_stat m where l.operatetime<(select date(current)-63 from systables where tabid=1)
and l.mainid=m.id and m.status=1);
update EST_LAST_OPER set last_operate_time=(select last_operate_time from EST_LAST_OPER where id=52) where id=5201;
shell脚本调用sql脚本 : del_sql.sh
#!/bin/csh
source /opt/informix/.cshrc
dbaccess bpedb /opt/eoms/informix/del.sql
informix sql 脚本:del.sql
linux定时执行存储过程,crontab 命令,存储过程在数据库中
#!/bin/csh
source /opt/inf