Hey Gurus..I am trying to figures out where my syntax is incorrect in the following SQL to to create an after insert trigger... I am getting
SQL0206N "INSERTROW.MF_USERID" is not valid in the context where it is used. LINE NUMBER=1. SQLSTATE=42703
CREATE TRIGGER "O000634"."test_insert"
AFTER
INSERT
ON "O000634"."TMAX300_USER"
REFERENCING
NEW AS "insertrow"
FOR EACH ROW
MODE DB2SQL
BEGIN ATOMIC
insert into O000634.TMAX300_USER_HISTORY ("MF_USERID", "SEC_MF_IND", "NET_ID", "FIRST_NAME", "MIDDLE_NAME",
"LAST_NAME", "PHONE", "PHONE_EXT", "FAX", "EMAIL", "AGENCY", "BUREAU",
"OMBBRN", "ROOM", "ADDRESS_1", "ADDRESS_2", "CITY", "STATE", "ZIPCODE",
"USER_STATUS", "ADMIN_USER", "COMMENT", "SDATE", "STIME", "SUSER", "CDATE",
"CTIME", "CUSER", "APPUSER", "ACTION")
VALUES
(insertrow.MF_USERID, insertrow.SEC_MF_IND, insertrow.NET_ID, insertrow.FIRST_NAME, insertrow.MIDDLE_NAME,
insertrow.LAST_NAME, insertrow.PHONE, insertrow.PHONE_EXT, insertrow.FAX, insertrow.EMAIL, insertrow.AGENCY, insertrow.BUREAU,
insertrow.OMBBRN, insertrow.ROOM, insertrow.ADDRESS_1, insertrow.ADDRESS_2, insertrow.CITY, insertrow.STATE, insertrow.ZIPCODE,
insertrow.USER_STATUS, insertrow.ADMIN_USER, insertrow.COMMENT, insertrow.SDATE, insertrow.STIME, insertrow.SUSER, insertrow.CDATE,
insertrow.CTIME, insertrow.CUSER, insertrow.APPUSER, 'INSERT');
END;