SET @MAXROWS = 'select max() from UNI452BFUB.MAINRECORDS;';

SET @ROWCNT = 1;

FOR_LOOP: FOR EACH_ROW AS C1 CURSOR FOR
	select distinct REFERENCENO, COMPANYCODE from UNI452BFUB.MAINRECORDS DO

	FOR_LOOP2: FOR EACH_ROW2 AS C2 CURSOR FOR
		SELECT
			UNI452BFUB.RECORDLINES.ID,
                      	UNI452BFUB.RECORDLINES.REFERENCENUMBER,
                      	UNI452BFUB.RECORDLINES.AMOUNT         
		FROM
                      	UNI452BFUB.RECORDLINES
		WHERE
			UNI452BFUB.RECORDLINES.REFERENCENUMBER = EACH_ROW.REFERENCENUMBER
    	DO
        	INSERT INTO UNI452BFUB.TEMP(ID, REFERENCENUMBER, AMOUNT) VALUES(EACH_ROW2.ID, EACH_ROW2.REFERENCENUMBER, EACH_ROW2.AMOUNT); 
              
	END FOR;
        RETURN(
        	SELECT
			UNI452BFUB.TEMP.ID,
			UNI452BFUB.TEMP.REFERENCENUMBER,
			UNI452BFUB.TEMP.AMOUNT           
		FROM
			UNI452BFUB.TEMP)
       
END FOR;

SQL State: 42601
Vendor Code: -199
Message: [SQL0199] Keyword END not expected. Valid tokens: UNION EXCEPT INTERSECT. Cause . . . . . :   The keyword END was not expected here.  A syntax error was detected at keyword END.  The partial list of valid tokens is UNION EXCEPT INTERSECT. This list assumes that the statement is correct up to the unexpected keyword.  The error may be earlier in the statement but the syntax of the statement seems to be valid up to this point. Recovery  . . . :   Examine the SQL statement in the area of the specified keyword.  A colon or SQL delimiter may be missing. SQL requires reserved words to be delimited when they are used as a name. Correct the SQL statement and try the request again.

Processing ended because the highlighted statement did not complete successfully

SELECT t1.id,
       t1.referencenumber,
       t1.amount
FROM   uni452bfub.recordlines AS t1
WHERE  t1.column-name IN
          ( SELECT t2.column-name
            FROM   uni452bfub.mainrecords )