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

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.