ALTER TABLE AKUZ.T_CDA_ONC_CONS_SUR_DETAIL ALTER COLUMN "surgprocedure" SET DATA TYPE varchar(6100);
UPDATE AKUZ.T_CDA_ONC_CONS_SUR_DETAIL SET "surgprocedure" = '' WHERE "surgprocedure" IS NULL;
ALTER TABLE AKUZ.T_CDA_ONC_CONS_SUR_DETAIL ALTER COLUMN "surgprocedure" SET NOT NULL;


ALTER TABLE AKUZ.T_CDA_SECTION_ONC_CONS_PATOBJ ALTER COLUMN "patientcondition" SET DATA TYPE varchar(4096);
UPDATE AKUZ.T_CDA_SECTION_ONC_CONS_PATOBJ SET "patientcondition" = '' WHERE "patientcondition" IS NULL;
ALTER TABLE AKUZ.T_CDA_SECTION_ONC_CONS_PATOBJ ALTER COLUMN "patientcondition" SET NOT NULL;