Fetch more than one rows without using CURSOR

gen_advantage · New User Joined: 05 Jun 2005 Posts: 5

Hai,
I want to fetch more than one rows,but i should not use CURSOR or SELECT * .

Is there any other way to do it?.

ikumar · New User Joined: 02 Aug 2005 Posts: 81

You must use cursor to retrieve more than one row in an application program. Please let us know what is exactly your requirement is, why u dont want to use cursor?

Anbudan · New User Joined: 07 Sep 2005 Posts: 26 Location: Germany

Hi gen_advantage

If U don't want to use cursor for multiple rows, then follow the steps:

i)Unload(JCL job) the records(rows) into a file
ii)Use this file as a input to ur cobol pgm

if you want more explanation regarding point (i),

feel free to ask

khamarutheen · Active Member Joined: 23 Aug 2005 Posts: 677 Location: NJ

hi frnd,
the DB2 intro the cursor ops only to retrv the multiple rows. if u are fetching more than one row without the cursor then error no.-811 will be thrown yar.

tam · New User Joined: 02 Nov 2005 Posts: 12 Location: zz

Yes, Cursor is the only option for retrieving multiple rows else -811 Sqlcode will result

tam · New User Joined: 02 Nov 2005 Posts: 12 Location: zz

-811 is the multiple row selected