This is a pretty snippet to create a iterator function with Sql. The main element is the CURSOR witch allows to cycle on a table like a for operator.

 if you want recall this procedure from the command line you only need to connect to the database and then enter

db2 "CALL iterator ()" 

CREATE PROCEDURE iterator()