-- ORDER 20010684 - Automated credit card processing - analysis change

ALTER TABLE CREDITCARDTRANSACTION ADD (PROCSTATUSMESSAGE_TMP CLOB, RESPCODEMESSAGE_TMP CLOB);
UPDATE CREDITCARDTRANSACTION  SET PROCSTATUSMESSAGE_TMP=PROCSTATUSMESSAGE;
COMMIT;
UPDATE CREDITCARDTRANSACTION  SET RESPCODEMESSAGE_TMP=RESPCODEMESSAGE;
COMMIT;

ALTER TABLE CREDITCARDTRANSACTION DROP COLUMN PROCSTATUSMESSAGE ;
ALTER TABLE CREDITCARDTRANSACTION DROP COLUMN RESPCODEMESSAGE;

ALTER TABLE CREDITCARDTRANSACTION RENAME COLUMN PROCSTATUSMESSAGE_TMP TO PROCSTATUSMESSAGE;
ALTER TABLE CREDITCARDTRANSACTION RENAME COLUMN RESPCODEMESSAGE_TMP TO RESPCODEMESSAGE;


