DELETE FROM "MBCONSTANT" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBER_TYPE" = :Original_MEMBER_TYPE)) INSERT INTO "MBCONSTANT" ("COOP_ID", "MEMBER_TYPE", "DOCCUMENT_CODE", "MEMBNO_FORMAT", "MEMNO_SUFFIX", "RETRY_AGE", "RETRY_DATE", "RETRY_TYPE", "MAXREGISTER_AMT", "MINRESIGN_MTH") VALUES (:COOP_ID, :MEMBER_TYPE, :DOCCUMENT_CODE, :MEMBNO_FORMAT, :MEMNO_SUFFIX, :RETRY_AGE, :RETRY_DATE, :RETRY_TYPE, :MAXREGISTER_AMT, :MINRESIGN_MTH) SELECT COOP_ID, MEMBER_TYPE, DOCCUMENT_CODE, MEMBNO_FORMAT, MEMNO_SUFFIX, RETRY_AGE, RETRY_DATE, RETRY_TYPE, MAXREGISTER_AMT, MINRESIGN_MTH FROM MBCONSTANT UPDATE "MBCONSTANT" SET "COOP_ID" = :COOP_ID, "MEMBER_TYPE" = :MEMBER_TYPE, "DOCCUMENT_CODE" = :DOCCUMENT_CODE, "MEMBNO_FORMAT" = :MEMBNO_FORMAT, "MEMNO_SUFFIX" = :MEMNO_SUFFIX, "RETRY_AGE" = :RETRY_AGE, "RETRY_DATE" = :RETRY_DATE, "RETRY_TYPE" = :RETRY_TYPE, "MAXREGISTER_AMT" = :MAXREGISTER_AMT, "MINRESIGN_MTH" = :MINRESIGN_MTH WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBER_TYPE" = :Original_MEMBER_TYPE))