Db2 Before Trigger Syntax

I've defined this trigger: CREATE TRIGGER actualizarSaldoIngreso BEFORE INSERT ON Ingreso FOR EACH ROW MODE DB2SQL BEGIN ATOMIC UPDATE Cliente SET Nombre = 'Juan' WHERE DNI = '

Solution 1:

You need to change terminator like this :

--#SET TERMINATOR @CREATETRIGGER actualizarSaldoIngreso
BEFORE INSERTON Ingreso
FOREACHROW MODE DB2SQL
BEGINATOMICUPDATE Cliente SET Nombre ='Juan'WHERE DNI ='87366034M';
END@
--#SET TERMINATOR ;

With a different terminator, the batch doesn't execute prematurely.