Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

By default, Cursor is readable or updateble

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
swati

New User


Joined: 14 Sep 2005
Posts: 7

PostPosted: Thu Nov 17, 2005 3:32 pm    Post subject: By default, Cursor is readable or updateble
Reply with quote

default cursor is readable or updateble?
Back to top
View user's profile Send private message

krishnaboya

New User


Joined: 17 Nov 2005
Posts: 3

PostPosted: Thu Nov 17, 2005 3:59 pm    Post subject: Re: DB2
Reply with quote

We can't say Cursor is by default Read only or updatable. It is depends on how do you define the cursor ....
Read only cursors are ...

1) If you define the cursor with for read only or for fetch only.
2) If you define the cursor with view which is read only.
3) If you define the cursor with UNION or Group By or Having or any User defined functions or Table functions
4) If you define the cursor with where clause

Updatable Cursors are ...
1) If you define a cursor with FOR UPDATE OF clause
Back to top
View user's profile Send private message
swati

New User


Joined: 14 Sep 2005
Posts: 7

PostPosted: Thu Nov 17, 2005 4:24 pm    Post subject: thanks alot
Reply with quote

Thanks for your reply
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Testing rerad cursor for status with ... John F Dutcher DB2 8 Fri May 19, 2017 9:35 pm
No new posts DFSORT - Overriding default option TU... Steve Ironmonger DFSORT/ICETOOL 3 Tue Apr 04, 2017 3:54 pm
No new posts Getting -504 Cursor Name GTT-ARTS-CUR... Robin Sulsona DB2 2 Fri Mar 17, 2017 1:43 am
No new posts Release of Adabas Cursor mohitsethi All Other Mainframe Topics 1 Mon Feb 06, 2017 8:36 pm
No new posts Updating Cursor row withour using FOR... chandan.inst DB2 15 Tue Nov 08, 2016 11:17 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us