CALL SYSPROC.ADMIN_CMD('load from (SELECT BILL_NO,CUS_NAME,LOAN_START_DATE,LOAN_END_DATE,LOAN_AMOUNT,REL_IR_M,PRD_NAME,MAIN_USR,MAIN_BCH,MODEL_PRD_CDE,FINISH_TYPE,ACCOUNT_STATUS FROM 表名 WHERE ACCOUNT_STATUS<>''3'') of cursor insert into 表名(BILL_NO,CUS_NAME,LOAN_START_DATE,LOAN_END_DATE,LOAN_AMOUNT,REL_IR_M,PRD_NAME,MAIN_USR,MAIN_BCH,MODEL_PRD_CDE,FINISH_TYPE)');
db2使用游标load数据
最新推荐文章于 2023-03-03 17:59:49 发布