Below are the tables and columns I am working with:
Table A: Key1, Points
Table B: Key1, Key2
Table C: Key2, Points
I would like to update the Points column in Table A with the corresponding value from Table C.
However, since there is not a direct key which relates Tables A & C, I will have to do a join which relates all three tables.
Initially I tried the following:
SET A.Points = C.Points
FROM A A
JOIN B B
ON A.Key1 = B.Key1
JOIN C C
ON B.Key2 = C.Key2
However, I get the error :
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD FROM. TOKEN ( .
MICROSECONDS MICROSECOND SECONDS SECOND MINUTES MINUTE WAS EXPECTED
I assume this is because a FROM statement is not allowed in this mainframe environment.
Anyone have any insight or suggestions for a workaround ?