Select more than one row without using a cursor

Aniyaa · New User Joined: 07 Dec 2007 Posts: 23 Location: Bangalore

Interview Qt :

How can I select more than one row without using a cursor in cobol-db2 batch program , using embedded sql.

stodolas · Posted: Thu Dec 27, 2007 6:17 pm Post subject:

You can't. Unless you run a new select for each row with a where that will only return one row.

Phrzby Phil · Posted: Thu Dec 27, 2007 6:36 pm Post subject:

COBOL allows selection into an array.

Srihari Gonugunta · Active User Joined: 14 Sep 2007 Posts: 164 Location: Pune

I suppose, there is some MULTI-ROW fetch cursor option in DB2V8 and V9, I haven't tried though.

Srihari Gonugunta · Active User Joined: 14 Sep 2007 Posts: 164 Location: Pune

ksk · Posted: Fri Dec 28, 2007 2:57 pm Post subject:

Put query in Perform loop and move the values into array.

priyamnavada · Posted: Wed Jan 23, 2008 2:29 pm Post subject:

perform the select query till the rows are not found. For each select place the data into the table.

the_gautam · Posted: Wed Jan 23, 2008 4:26 pm Post subject:

we cant select multiple row without using cursors in DB2-COBOL batch programs.

vkphani · New User Joined: 29 Oct 2003 Posts: 30

If you have db2 version 7 then you can use the following query to get N rows of a table.