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

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others