CREATE TRIGGER TG1
AFTER INSERT ON TABLE1
REFERENCING NEW AS N
FOR EACH ROW MODE DB2SQL
DECLARE X CHAR(1);
DECLARE Y CHAR(9);
SET (X,Y) = (SELECT OWN_TYPE, EMP_NO
FROM TABLE2 B
WHERE B.BAR_CODE = N.BAR_CODE
AND B.CURRENT = 'C')
I am also getting the -20100 SQL abend with SQLCODE=-199 at the time of execution of First Declare statement.
when i check QW, A syntax error was detected in the statement at the point where the keyword keyword appears.
And also saying partial list of VALID tokens is provided in SQLERRM as token-list.
But I couldn't get the valid list and I am not able to execute that trigger.
Can you please help me on how to get the valid list else what all token can i use as variables?