I am losing my mind and there are very few examples on the Internet to compare to.
Here is my trigger:
CREATE TRIGGER IDMSIS.TGR_IDM_NAME_u
OF PERSON_ID, LAST_NAME, FIRST_NAME, MIDDLE_NAME, DATE_OF_BIRTH,
GENDER, SSN, DIRECTORY_RELEASE_FLAG, PIN, ALUMNUS_FLAG
REFERENCING OLD AS o
FOR EACH ROW MODE DB2SQL
INSERT INTO IDMSIS.T_IDM_EVENT_PROCESS
SELECT ('PK_PERSON_ID=' || o.PERSON_ID),
'IDMSIS.V_IDM_STUDENT' FROM IDMSIS.event_time;
And I keep getting:
SQL0104N An unexpected token "END-OF-STATEMENT" was found following "OM
IDMSIS.event_time". Expected tokens may include: "JOIN <joined_table>".
LINE NUMBER=17. SQLSTATE=42601
I've been staring at this for three hours and I can't find anything wrong with it.