how to reteieve the cursor randomly??

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
bnirmalraj
Member
Posts: 5
Joined: Wed Sep 20, 2006 11:15 am

how to reteieve the cursor randomly??

Post by bnirmalraj » Wed Oct 11, 2006 5:57 pm

hi all
how to reteieve the cursor randomly??

User avatar
Kalicharan
Moderator
Posts: 31
Joined: Wed Feb 08, 2006 1:51 pm

Post by Kalicharan » Sat Oct 14, 2006 12:04 pm

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

Post Reply