CREATE TRIGGER TRIG1
AFTER INSERT
ON TBN1
REFERENCING NEW_TABLE AS inserted
FOR EACH STATEMENT
MODE DB2SQL
BEGIN ATOMIC
   DECLARE v_IdGoReal INTEGER;
   DECLARE v_IdParentUID INTEGER;
   DECLARE Fetch_stat INTEGER DEFAULT  0 ;
   DECLARE cur_TBN1I CURSOR    FOR
   SELECT * FROM Inserted I;
   DECLARE CONTINUE HANDLER FOR NOT FOUND SET Fetch_stat = - 1 ;
   IF EXISTS(SELECT  1  FROM Inserted I WHERE I.NewUID IS NULL) then
	
      OPEN cur_TBN1I;
      FETCH cur_TBN1I INTO v_IdGoReal,v_IdParentUID;
      WHILE Fetch_stat =  0  DO
         SWL_Label:
         WHILE  1  =  1  DO
            UPDATE TBN1 SET NewUID = v_IdParentUID WHERE IdGoReal = v_IdGoReal;
            FETCH cur_TBN1I INTO v_IdGoReal,v_IdParentUID;
            LEAVE SWL_Label;
         END WHILE;
      END WHILE;
      CLOSE cur_TBN1I;
   end if;
END