CREATE TABLE INT.VAL (
  ID	SMALLINT	NOT NULL PRIMARY KEY GENERATED ALWAYS  AS IDENTITY (START WITH 1, INCREMENT BY 1),
  NAME VARCHAR(10) NOT NULL
  ) 

CREATE TABLE INT.VAT_DICT (
  ID	INTEGER	NOT NULL	GENERATED ALWAYS  AS IDENTITY (START WITH 1, INCREMENT BY 1),
  VAL_ID	INTEGER	NOT NULL,
  LANG	INTEGER	NOT NULL,
  NAME	VARCHAR(255)	NOT NULL, 
  CONSTRAINT FK1 FOREIGN KEY(VAL_ID) REFERENCES INT.VAT_DICT(ID)  ON DELETE CASCADE  ON UPDATE RESTRICT ENFORCED  
  ) 
  IN TS_4K;

CREATE TABLE INT.HISTORY_DICTIONARY (
  ID	BIGINT	NOT NULL	GENERATED ALWAYS
    AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE,
       NO MINVALUE, NO MAXVALUE, NO CYCLE, NO ORDER),
  DATE_TIME	TIMESTAMP 	NOT NULL	DEFAULT ,
  MESSAGE	varchar(10)	NOT NULL,
  COLUMN_NAME	VARCHAR(100)	NOT NULL,
  OLD_VAL	CLOB(8K)	 INLINE LENGTH 92	LOGGED	COMPACT,
  NEW_VAL	CLOB(8K)	 INLINE LENGTH 92	LOGGED	COMPACT
  ) 

 CREATE TRIGGER INT.DEL_LOG
  AFTER DELETE
  ON INT.VAT
  REFERENCING 
    OLD AS OLD_ROW
  FOR EACH ROW
  begin atomic
insert into int.history_dictionary(DATE_TIME,message,COLUMN_NAME,OLD_VAL)
values(CURRENT TIMESTAMP,'FACT','NAME',OLD_ROW.NAME);
  END;

DELETE FROM INT.VAL
WHERE ID = 1