I have a problem calling a recursive routine in Natural DB/2. On the second call it returns a SQLSTATE error 24502 - cursor already open. The call is done within the loop of a Select statement. Some of the information I have gleaned from Google, seems to indicate that DB/2 only allows recursion if the SQL statements are within the context of a stored procedure.
Any comments and/or source code