Hi All,

I am migrating a database from Firebird/Interbase to DB2 and have having issues with the stored procedures/functions.

I have a number of functions that loop over a FOR loop, each pass it performs some logic on the row and inserts the output data into a temp table. The only point of the insert is so that I can select the data in a RETURN statement at the end of the UDF.

In Firebird we could put...