types of cursors?

other mainframe interview questions

Moderators: Anuj Dhawan, Moderator Group

Post Reply
User avatar
arrbee
Active Member
Posts: 144
Joined: Fri Feb 24, 2006 11:33 am

types of cursors?

Post by arrbee » Thu Mar 09, 2006 7:58 pm

Hi,

How many types of cursors are there in DB2? What are they?

Thanks.
Arr Bee
-------------
?My joy in learning is partly that it enables me to teach? - Seneca(Roman philosopher, mid-1st century AD)

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

Post by Kalicharan » Wed Mar 15, 2006 4:03 pm

Hi,

There are 3 types of CURSORS in DB2.

Read only
Updatable
Ambiguous

Read-only can be used for all Isolation Levels (UR,CS,RS,RR)

Updatable can be used for all Isolation levels except UR


An ambiguous cursor is that if DB2 cannot tell whether it is used for update or read-only purposes. If the cursor appears to be used only for read-only, but dynamic SQL could modify data through the cursor, then the cursor is said to be ambiguous



Thanks
Kalicharan

Guest

Post by Guest » Thu Mar 16, 2006 9:23 am

Thanks Kalicharan.

- RB.

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