Problems with a simple Trigger :-(

[rushpuppy]

Helo everybody
i am trying to make a trigger. But my trigger generates me an error i can not explain.

This is my trigger code:

-- This script has been created using ^ as the termination character.
-- If you wish to execute this script through the CLP, you will need 
-- to add the CLP option -td"^" to your command line,  for example:
-- db2 -td"^" -f filename.ddl

CONNECT TO DACODB2^
CREATE TRIGGER FASTMAIN.TR_TEST NO CASCADE BEFORE  INSERT  ON FASTMAIN.IMP_TAB_RECORDS  REFERENCING  NEW AS NEW_KEY  FOR EACH ROW  MODE DB2SQL 
BEGIN ATOMIC
--
DECLARE proc_pointer_from INTEGER DEFAULT 0;
DECLARE proc_pointer_to INTEGER DEFAULT 0;
DECLARE proc_pointer_last INTEGER DEFAULT 0;
DECLARE proc_pointer_incr INTEGER DEFAULT 0;
--

--
SET (proc_pointer_from,proc_pointer_to,proc_pointer_last,proc_pointer_incr)=(SELECT pointer_from,pointer_to,pointer_last,pointer_increment FROM pointer WHERE pointer_id='IMP001');
--

--
SET proc_pointer_last=proc_pointer_last+proc_pointer_incr;
IF proc_pointer_last>proc_pointer_to THEN
SET proc_pointer_last=proc_pointer_from;
END IF;
--

--
UPDATE pointer SET pointer_last=proc_pointer_last WHERE pointer_id='IMP001';
--

--
SET NEW_KEY.IMPTR_KEY=proc_pointer_last;
--

END^
CONNECT RESET^

But DB2 has a problehm with the folowing statement of my code:
„UPDATE pointer SET pointer_last=pr oc_pointer_last WHERE pointer_id='IMP 001';
“

When i try to create my trigger DB2 says :

"The trigger "FASTMAIN.TR_TE ST" is defined with an unsupported triggered SQL "


Pleasy help me i have no idea why this normal SQL statement is not correct.
an exuse me for my bad english :-)

Greeetings

[kazam]

Can you paste the error message here. So that it would become easy to identify the problem