DB2合并到循环
问题描述:
我遇到了一个问题,即我的日志文件在我的合并完成之前就已经满了。有没有办法我可以迭代这个合并来一次合并1000,提交并重新开始?这里是我的MERGE语句:DB2合并到循环
MERGE INTO "SCHEMA"."PATIENT" AS DMT
USING "SCHEMA"."PATIENT_STAGE" AS Stage
ON (DMT.MEMBER_ID = Stage.MEMBER_ID)
when matched then
update set
DMT.MEMBER_ID = Stage.MEMBER_ID,
DMT.ADDRESS1 = Stage.ADDRESS1,
DMT.ADDRESS2 = Stage.ADDRESS2,
DMT.BENEFIT_ID = Stage.BENEFIT_ID,
DMT.CITY = Stage.CITY,
DMT.STATE = Stage.STATE,
DMT.CLIENT_CLIENT_ID = Stage.CLIENT_CLIENT_ID,
DMT.CLIENT_CUSTOMER_ID = Stage.CLIENT_CUSTOMER_ID,
DMT.CLIENT_GROUP_ID = Stage.CLIENT_GROUP_ID,
DMT.DATE_OF_BIRTH = Stage.DATE_OF_BIRTH,
DMT.FIRST_NAME = Stage.FIRST_NAME,
DMT.GENDER = Stage.GENDER,
DMT.LAST_NAME = Stage.LAST_NAME,
DMT.MIDDLE_NAME = Stage.MIDDLE_NAME,
DMT.PERSON_CODE = Stage.PERSON_CODE,
DMT.SSN = Stage.SSN,
DMT.TPL_PAYOR = Stage.TPL_PAYOR,
DMT.TPL_PRIM_NAME = Stage.TPL_PRIM_NAME,
DMT.UPDATE_DATE = Stage.UPDATE_DATE;
COMMIT;
答
这似乎解决我的问题:
num=1 ; while ((num < 100000)) ; do
MERGE INTO "SCHEMA"."PATIENT" AS DMT
USING "SCHEMA"."PATIENT_STAGE" AS Stage
update set
DMT.MEMBER_ID = Stage.MEMBER_ID,
DMT.ADDRESS1 = Stage.ADDRESS1,
DMT.ADDRESS2 = Stage.ADDRESS2,
DMT.BENEFIT_ID = Stage.BENEFIT_ID,
DMT.CITY = Stage.CITY,
DMT.STATE = Stage.STATE,
DMT.CLIENT_CLIENT_ID = Stage.CLIENT_CLIENT_ID,
DMT.CLIENT_CUSTOMER_ID = Stage.CLIENT_CUSTOMER_ID,
DMT.CLIENT_GROUP_ID = Stage.CLIENT_GROUP_ID,
DMT.DATE_OF_BIRTH = Stage.DATE_OF_BIRTH,
DMT.FIRST_NAME = Stage.FIRST_NAME,
DMT.GENDER = Stage.GENDER,
DMT.LAST_NAME = Stage.LAST_NAME,
DMT.MIDDLE_NAME = Stage.MIDDLE_NAME,
DMT.PERSON_CODE = Stage.PERSON_CODE,
DMT.SSN = Stage.SSN,
DMT.TPL_PAYOR = Stage.TPL_PAYOR,
DMT.TPL_PRIM_NAME = Stage.TPL_PRIM_NAME,
DMT.UPDATE_DATE = Stage.UPDATE_DATE(select........where <> fetch 1st 1000 rows only)
(num=num+1)
done
日志是什么消息填满? – danny117
@ danny117我认为OP意味着交易日志。 – mustaccio
正确 - 事务日志正在填充。由于我使用SSIS运行,因此我无法关闭日志记录。 –