UPDATE KK_T_KNYTCS KK3011 SET KK3011.KNYTCS_STAT = '100', KK3011.KNYTCS_PRINT_REQYMD = '${KNYTCS_PRINT_REQYMD}', KK3011.UPD_UNYO_YMD = '${UPD_UNYO_YMD}', KK3011.UPD_TRN_ID = '${UPD_TRN_ID}', KK3011.UPD_DTM = '${UPD_DTM}', KK3011.UPD_OPEACNT = '${UPD_OPEACNT}' WHERE KK3011.KNYTCS_STAT = '010' AND KK3011.MK_FLG = '0' AND KK3011.KNYTCS_KOHU_WAY_CD = '3'; COMMIT; EXIT 0 quit