create triggers

[Omar Vazquez]

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

[Serge Rielau]

Omar Vazquez wrote:

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

Omar,

How do you run the script?
Make sure that after the END of the trigger statement you use a
character different from ';'. Popular are '$', '#' or '!'.
Then use that character in comntrol center as termination character for
tools-settings and/or use db2 -td$ -f <file> to run the script.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[J.Haan]

On Mon, 24 Jan 2005 14:25:51 -0800, Omar Vazquez wrote:

If you created the script on a windows machine, remember to run dos2unix
before you try to execute it on a unix machine. (different newline
interpretation).

-R-