hellomdp
asked on
Embedded Cursors
Is it possible to have cursors within cursors in Mainframe DB2 ? Is this the same as Scrollable cursors ? If cursor in curor is possible, where can i get more info about it ? Thanks.
ASKER
No. I have used multiple cursors, and that concept is fine.
An analogy, SUBSELECT ===> This is a SELECT within a SELECT. Similarly, Can we have a cursor within a cursor ?
Thanks,
hellomdp.
An analogy, SUBSELECT ===> This is a SELECT within a SELECT. Similarly, Can we have a cursor within a cursor ?
Thanks,
hellomdp.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok...thanks.
You can open multiple cursors at one time. For ex., you can open cursor1, fetch a row, open cursor2 based on the row fetched from cursor1, nest the loops, etc.
Lloyd