I build a join like this:
First I join a hold file with a DB2 table, then I Join the same Hold file with another Hold File:
JOIN FIELD1 IN MYNAMES TO FIELD2 IN DB2TABLE AS J1
JOIN FIELD3 IN MYNAMES TO ALL FIELD3 IN MYHOLD AS J2
(FIELD1 and FIELD2, FIELD3 and FIELD4 have the same format, I checked that with ? HOLD)
I then get the following error:
(FOC1070) VALUE FOR JOIN 'FROM' FIELD OUT OF SEQUENCE. RETRIEVAL ENDED.
I don't quiet understand what that means. Because in a similar join I didn't sort the joning fields neither and that join worked. Can anybody explain?