Mainframe, MVS and zOS Discussion

Posted: **Fri Jan 14, 2022 8:32 pm**

Hi All,

I have been asked this interview question which I could not answer - How to fetch multiple rows and move to output(30 occurrences)?

Can someone please help me with some answer or direction.

Posted: **Wed Jan 26, 2022 10:33 pm**

CURSOR with or without ROWSET POSITIONING can be used. 'Host-variable-array' should be defined with 30-occurrences for your example.

Hope this helps.

Mainframe, MVS and zOS Discussion

DB2 interview question on fetching rows.

DB2 interview question on fetching rows.

Re: DB2 interview question on fetching rows.