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_U SERID" is not valid in the context where it is used. LINE NUMBER=1. SQLSTATE=42703
CREATE TRIGGER "O000634"."test _insert"
AFTER
INSERT
ON "O000634"."TMAX 300_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_NAM E",
"LAST_NAME" , "PHONE", "PHONE_EXT" , "FAX", "EMAIL", "AGENCY", "BUREAU",
"OMBBRN", "ROOM", "ADDRESS_1" , "ADDRESS_2" , "CITY", "STATE", "ZIPCODE",
"USER_STATU S", "ADMIN_USER ", "COMMENT", "SDATE", "STIME", "SUSER", "CDATE",
"CTIME", "CUSER", "APPUSER", "ACTION")
VALUES
(insertrow.MF_U SERID, insertrow.SEC_M F_IND, insertrow.NET_I D, insertrow.FIRST _NAME, insertrow.MIDDL E_NAME,
insertrow.LAST_ NAME, insertrow.PHONE , insertrow.PHONE _EXT, insertrow.FAX, insertrow.EMAIL , insertrow.AGENC Y, insertrow.BUREA U,
insertrow.OMBBR N, insertrow.ROOM, insertrow.ADDRE SS_1, insertrow.ADDRE SS_2, insertrow.CITY, insertrow.STATE , insertrow.ZIPCO DE,
insertrow.USER_ STATUS, insertrow.ADMIN _USER, insertrow.COMME NT, insertrow.SDATE , insertrow.STIME , insertrow.SUSER , insertrow.CDATE ,
insertrow.CTIME , insertrow.CUSER , insertrow.APPUS ER, 'INSERT');
END;