create trigger as.kntoldtrigger before insert on as.employee
REFERENCING NEW AS mynewrows 
for each row mode db2sql 
begin atomic 
delete from as.employee where id=mynewrows.oldid end

SQL State: 0W000
Vendor Code: - 751 
Message: [SQL0751] SQL statement *N not allowed. Cause . . . . . :   The statement *N is not allowed 
in a stored procedure, user-defined function, or trigger. -- Statements not allowed in a trigger program 
are CONNECT, SET CONNECTION, RELEASE, DISCONNECT, and SET RESULT SETS. -- RUNSQLSTM is not 
allowed in a trigger program. -- COMMIT and ROLLBACK are not allowed in a trigger program if the 
trigger program is running in the same activation group as the triggering program.  COMMIT and 
OLLBACK are not allowed in an SQL trigger. -- ALTER TABLE is not allowed in a trigger program when 
commitment control is active. -- Statements not allowed in a stored procedure or user-defined function 
that is running on a remote application server are CONNECT, SET CONNECTION, RELEASE, DISCONNECT, 
COMMIT, ROLLBACK, and SET TRANSACTION. -- Statements not allowed in an SQL BEFORE trigger are 
INSERT, UPDATE, DELETE, ALTER TABLE, COMMENT ON, CREATE, DROP, GRANT, LABEL ON, RENAME, 
REVOKE, REFRESH TABLE, and ALTER PROCEDURE. -- The RETURN statement is not allowed in an SQL 
trigger. -- Statements not allowed in a secondary thread are CREATE TRIGGER, CREATE FUNCTION 
(SQL), CREATE PROCEDURE (SQL), and ALTER PROCEDURE (SQL). Recovery  . . . :   Remove the 
statement *N from your trigger program, user-defined function, or stored procedure. Try the request 
again.


Processing ended because the highlighted statement did not complete successfully