How to fetch more than one rows using cursors in db2

See more:

DB2

How to fetch more than one rows using cursors in db2?

I'm using cursor to fetch records from a table. Am just able to fetch only one row at a time. Need to fetch more than one records. Please help.

CREATE or REPLACE PROCEDURE RTIMD.TicketDaemonProc (IN IN_RTIM_ID VARCHAR(50) default '', IN usr_name VARCHAR(20) DEFAULT '',
IN api_method VARCHAR(50) DEFAULT '', IN params VARCHAR(2500) default '', IN application_name VARCHAR(20) default '', OUT V_OUT VARCHAR(2000))

LANGUAGE SQL BEGIN
DECLARE USER_IDS VARCHAR(5000);

DECLARE cursor1 CURSOR WITH RETURN FOR select USER_ID from RTIMD.V3_SERVICE_NOW_ASSIGNMENT_GROUPS where GROUP_ID = IN_RTIM_ID;

OPEN cursor1; FETCH FROM cursor1 INTO USER_IDS; CLOSE cursor1;

Thanks in advance.