当前位置: 代码迷 >> 综合 >> db2使用游标load数据
  详细解决方案

db2使用游标load数据

热度:68   发布时间:2024-01-26 16:46:47.0

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)');

  相关解决方案