--前期准备数据
三个表数据: s_subjtotal_year, subject_item, branch ,decrsubjtotal
---informix 查看数据库剩余空间
select d.name dbspace,
sum(c.chksize*d.pagesize/1020/1024) allocated_MB,
sum(c.nfree*d.pagesize/1020/1024) free_MB,
round(((sum(c.chksize)-sum(c.nfree))/sum(c.chksize))*100)||"%" pcused
from sysmaster:sysdbspaces d,sysmaster:syschunks c
where d.dbsnum=c.dbsnum
group by d.name
order by 2;
select distinct datekey from decrsubjtotal where datekey>='2013-01-01';
------------年终结算跑数据流程
--bvdb.jar 包 git.bankview.bl.pump.bhrs.cbsYearGeneralLedger;
delete from taskschedule where datekey='20131231' and taskid='100';
insert into taskschedule (datekey,taskid,execurl,retrymax,statuscode,exectime,termtime,retrytimes,errmsg)
values ('20131231','100','class://git.bankview.bl.pump.bhrs.cbsYearGeneralLedger;params=C','0','5','','','0','');
delete from taskdependence where datekey='20131231' and taskid='101' and deptaskid='100';
insert into taskdependence (datekey,taskid,deptaskid) values
('20131231','101','100');
--修改 bhrs.sh
select * from taskdependence;
update taskschedule set statuscode='1' where datekey="${DATE}";
为
update taskschedule set statuscode='1' where datekey="${DATE}" and taskid!='100';
--年终的操作步骤
核心提供的年终结算总账表导入s_subjtotal_year表里
然后update taskschedule set statuscode='1' where datekey="20131231" and taskid='100';
启动报表任务服务器等待该任务跑完.
--1 建表
create table s_subjtotal_year
(
datekey date not null ,
deptid char(12) not null ,
curid char(10) not null ,
subjid char(20) not null ,
balref smallint,
debal decimal(16,2),
crbal decimal(16,2),
deamt decimal(16,2),
cramt decimal(16,2),
decnt integer,
crcnt integer,
primary key (datekey,deptid,curid,subjid,balref)
); --in dtdbs;
revoke all on s_subjtotal_year from "public" as "informix";
create index idx_s_subjtotal_year1 on s_subjtotal_year
(datekey) using btree in datadbs;--dtixdbs;
create index idx_s_subjtotal_year2 on s_subjtotal_year
(datekey,deptid,curid,subjid) using btree in datadbs;-- dtixdbs;
create index idx_s_subjtotal_year3 on s_subjtotal_year
(datekey,deptid) using btree in datadbs;--dtixdbs;
create index idx_s_subjtotal_year4 on s_subjtotal_year
(datekey,subjid) using btree in datadbs;--dtixdbs;