CTP

1.结算价0改1 update operation.t_marketdata t set t.settlementprice = '1' where t.exchangeid = 'SHFE' and t.settlementprice = '0';
2.select uf_getversion from dual
3.systemstatus系统状态 select * from t_settledate;
4.提示交易所同步结算价信息到结算系统出错(某些交易所没开,所接结算价为0),修改结算价再切结算
update operation.t_marketdata t set t.settlementprice = 1 where settlementprice='0';
commit;
5.清结算上传文件 select * from t_uploadfile where exchangeid = 'DCE' FOR UPDATE
6.select * from t_operationlog where tradingday = '20231108';
7.select * from t_eventlog;
8.select * from t_fundeventlog;
9.select* from t_uploadfile;
10.select * from t_settledate 修改结算单状态billgenstatus ,2是生成,