creating triggers in db2

[Prasad]

Hi I am new to db2 and need to create a trigger. I tried the following
CREATE TRIGGER TRGINTST_HIST AFTER UPDATE ON
INTERSTATES REFERENCING OLD AS old
FOR EACH ROW MODE DB2SQL

BEGIN ATOMIC
INSERT INTO INTERSTATES_HIST(USER_ID,ID) VALUES ( USER, old.ID) ;
END;

When I eqecute the above in the command center I am getting the
following error

__________________________________________________ _____________________________
INSERT INTO INTERSTATES_HIST(USER_ID,ID) VALUES ( USER, old.ID)

DB21034E The command was processed as an SQL statement because it was
not a

valid Command Line Processor command. During SQL processing it
returned:

SQL0104N An unexpected token "END-OF-STATEMENT" was found following
"LUES (

USER, old.ID)". Expected tokens may include: "<delim_semicolon>".
LINE

NUMBER=7. SQLSTATE=42601
END

DB21034E The command was processed as an SQL statement because it was
not a

valid Command Line Processor command. During SQL processing it
returned:

SQL0104N An unexpected token "END-OF-STATEMENT" was found following
"END".

Expected tokens may include: "JOIN <joined_table>". SQLSTATE=42601
__________________________________________________ ____________________________

I ran out of all ideas. i had set the delimiter to ; in the command
center. Can some please help in solving the problem.
Thanks in advance,
Prasad.

[Serge Rielau]

This is the most common SQL PL trap.
You need to change the delimiter of your interface.
E.g. enter the CLP via db2 -td%
Then concluse the create trigger statement with '%' (or another funky
character.
From command center you do it in "Tools Settings"
If you don't do this the client thinks your statement ends at teh first
';' found.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab