Page 1 of 1
how to reteieve the cursor randomly??
Posted: Wed Oct 11, 2006 5:57 pm
by bnirmalraj
hi all
how to reteieve the cursor randomly??
Posted: Sat Oct 14, 2006 12:04 pm
by Kalicharan
Hi,
If your requirement is random access to a resultant table
you can achieve by scrollable cursor.
This mode enables random access to rows in a result set, but currently is supported only by IBM DB2 Universal Database.
Scrollable cursors allow random access to a result table. Applications can use a powerful set of SQL to fetch data using a cursor in random order. Scrollable cursors are especially useful for screen-based applications. You can specify that the data in the result table is to remain static, or you can perform the data updates dynamically.
Thanks
Kalicharan