我要导入一张表的数据
现在这个表的基数 上亿 。我想每100W条数据提交一次。防止日志爆满。
谁清楚这个语句怎么写哦
IMPORT FROM "E:h_leav" OF DEL METHOD P (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37) MESSAGES "E:ins1" INSERT INTO DB2ADMIN.H_LEAVEHOSCHARGE_DETAIL_BAK (INHOSID, CURRENTINHOSMARK, DIAGNOSEID, DETAILACCOUNTID, BILLID, ITEMID, UNITPRICE, AMOUNT, MONEY, BILLOFOFFICEID, EXECOFFICEID, OCCUROFFICEID, BILLOFDOCTORID, OPERATEDATE, OPERATORID, ACCOUNTSTYPE, CASHDEFRAY, ACCOUNTDEFRAY, DISCOUNTPAY, LOWMONEYPAY, CANCELMARK, CHECKID, MEDICARETYPE, OCCURDATE, CANCELDETAILACCOUNTID, ESCAPECHARGEMARK, UNITECODE, UNITENAME, TRANSNUMBER, UPLOADTIME, DISCOUNTDEFRAY, HOSCOMMITMENT, MEDMONEY, MEDSELFMONEY, SELFMONEY, CHARGELEVEL, SELFMONEYMARK);