The result of a SELECT Statement which returns more than one row, is easy to view on an SQL interface like STRSQL. But How can we handle this result set pragmatically in Embedded SQL or SQL/PL code?
The answer is SQL CURSOR.
CURSOR provides a simple way to access Result Set returned by SELECT Statement. You can think of CURSOR as a pointer to one row in a ResultSet containing multiple rows. So at a time cursor can reference only one row, but It can move to other rows of ResultSet as required.