|
View previous topic :: View next topic
|
| Author |
Message |
babu_hi
New User
Joined: 11 Apr 2006
Posts: 93
|
|
|
|
i am posting one of the interview question below,
How get Multipul rows without using cursor? |
|
| Back to top |
|
 |
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
| Back to top |
|
|
kondru
New User
Joined: 22 Mar 2010
Posts: 11
Location: india
|
|
|
|
Hello Babu,
Cursor will be used to address the individual row, When your SQL is returned more than one row.. I dont think, handling multiple rows is possible.
Regards,
KDR |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| I dont think, handling multiple rows is possible. |
Yes, it is. Suggest you look in the db2 sql manual for "host-variable array".
Both multi-row insert and multi-row fetch are supported. . . And these have significant performance improvements over one-row-at-a-time. . .
But keep in mind the original question was how to to fetch multiple rows without a cursor. |
|
| Back to top |
|
|
kaustubhkhole
New User
Joined: 20 Oct 2008
Posts: 19
Location: Hyderabad
|
|
|
|
gr8 Find indeed  |
|
| Back to top |
|
|
|
|
