HI, I HOPE SOMEBODY CAN HELP ME WITH THIS, I´M TRYING TO CREATE A
TRIGGER WITH A SCRIPT, BUT WEND I RUN IT ALWAYS SEND ME A ERROR
"SQL0104N  Se ha encontrado una señal imprevista
"END-OF-STATEMENT" a continuación de "END".  Entre las señales
esperadas se puede incluir: "JOIN <joined_table>".

THIS IS THE SCRIPT, I LIKE TO USE A SCRIPT TO CREATE ALL MY TRIGGERS
(8 0R 10) BECAUSE EVERY TIME I NEED TO CREATE THEM I HAVE TO USE THE
WIZARD OF CONTROL CENTER. AND THAT'S A HEAD ACHE.

CREATE TRIGGER LEDAT.INGOBS AFTER  INSERT  ON LEDAT.ICITEM
REFERENCING  NEW AS FN  FOR EACH ROW  MODE DB2SQL

/*
*SI EL VALOR RECIBIDO ES MAYOR A CERO ENTONCES SE CONSIDERA
*QUE EL CAMPO LLEVA UN VALOR VALIDO
*/
WHEN (LENGTH(LTRIM(FN.DEFPRICLST)) > 0)
BEGIN ATOMIC
INSERT INTO LEDAT.OBSERVACIONES (IDPROD,IDLISPRE) VALUES (FN.ITEMNO,
FN.DEFPRICLST);
END