|
View previous topic :: View next topic
|
| Author |
Message |
Aniyaa
New User
Joined: 07 Dec 2007
Posts: 26
Location: Bangalore
|
|
|
|
Interview Qt :
How can I select more than one row without using a cursor in cobol-db2 batch program , using embedded sql. |
|
| Back to top |
|
 |
stodolas
Active Member
Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin
|
|
|
|
| You can't. Unless you run a new select for each row with a where that will only return one row. |
|
| Back to top |
|
|
Phrzby Phil
Senior Member
Joined: 31 Oct 2006
Posts: 1042
Location: Richmond, Virginia
|
|
|
|
| COBOL allows selection into an array. |
|
| Back to top |
|
|
Srihari Gonugunta
Active User
Joined: 14 Sep 2007
Posts: 295
Location: Singapore
|
|
|
|
| I suppose, there is some MULTI-ROW fetch cursor option in DB2V8 and V9, I haven't tried though. |
|
| Back to top |
|
|
Srihari Gonugunta
Active User
Joined: 14 Sep 2007
Posts: 295
Location: Singapore
|
|
| Back to top |
|
|
ksk
Active User
.jpg)
Joined: 08 Jun 2006
Posts: 355
Location: New York
|
|
|
|
| Put query in Perform loop and move the values into array. |
|
| Back to top |
|
|
priyamnavada
New User
Joined: 24 Dec 2005
Posts: 52
Location: hyderabad
|
|
|
|
| perform the select query till the rows are not found. For each select place the data into the table. |
|
| Back to top |
|
|
the_gautam
Active User
Joined: 05 Jun 2005
Posts: 165
Location: Bangalore
|
|
|
|
| we cant select multiple row without using cursors in DB2-COBOL batch programs. |
|
| Back to top |
|
|
vkphani
New User
Joined: 29 Oct 2003
Posts: 29
|
|
| Back to top |
|
|
|
|
