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
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
Posts: 31
Joined: Wed Feb 08, 2006 1:51 pm

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


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.


Post Reply


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.
Mainframe Interview questions

Other References
Mainframe Tools and others