CREATE TRIGGER C_D_T_INS
INSTEAD OF INSERT
ON CENTER_DEVICE_TYPE_ACTUAL
REFERENCING NEW AS INSERTED_RECORD FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC 
DECLARE CHANGE_ID INTEGER;

CALL SetChangeBySessionId(INSERTED_RECORD.SESS_ID, CHANGE_ID);

INSERT INTO CENTER_DEVICE_TYPE (RECSTATE, SESS_ID, ENTITY_ID, CREATE_DATE, DELETE_DATE, CREATION_ID, DELETION_ID,
 DEV_CODE, DEVICE_NAME, DEVICE_MARK, TYPE_STR, NORMA_CODE, CODIFF, ORIGINAL_CODIFF, TIME_NORMA, TARIFF, PERIOD, ORIGINAL_PERIOD, GOS_NO, METHOD, MEASURE_TYPE_CODE_ID, MARK_TYPE_ID, DEPRECATED,
 GRADE_OF_ACCURACY, MEASUREMENT_RANGE, CERTIFICATION_NUMBER, CERTIFICATION_FINISH_DATE, MANUFACTURER, METROLOGICAL_BEHAVIOURS )
 VALUES(  1 , NULL, NULL, CURRENT TIMESTAMP, NULL, CHANGE_ID, NULL,
     INSERTED_RECORD.DEV_CODE, INSERTED_RECORD.DEVICE_NAME, INSERTED_RECORD.DEVICE_MARK, INSERTED_RECORD.TYPE_STR, INSERTED_RECORD.NORMA_CODE, INSERTED_RECORD.CODIFF, INSERTED_RECORD.ORIGINAL_CODIFF, INSERTED_RECORD.TIME_NORMA, INSERTED_RECORD.TARIFF, INSERTED_RECORD.PERIOD, INSERTED_RECORD.ORIGINAL_PERIOD, INSERTED_RECORD.GOS_NO, INSERTED_RECORD.METHOD, INSERTED_RECORD.MEASURE_TYPE_CODE_ID, INSERTED_RECORD.MARK_TYPE_ID, INSERTED_RECORD.DEPRECATED,
	 INSERTED_RECORD.GRADE_OF_ACCURACY, INSERTED_RECORD.MEASUREMENT_RANGE, INSERTED_RECORD.CERTIFICATION_NUMBER, INSERTED_RECORD.CERTIFICATION_FINISH_DATE, INSERTED_RECORD.MANUFACTURER, INSERTED_RECORD.METROLOGICAL_BEHAVIOURS);

UPDATE CENTER_DEVICE_TYPE 
 SET ENTITY_ID = CENTER_ID 
 WHERE CENTER_ID = IDENTITY_VAL_LOCAL();
END;

UPDATE CENTER_DEVICE_TYPE 
 SET ENTITY_ID = CENTER_ID 
 WHERE CENTER_ID = INSERTED_RECORD.CENTER_ID