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 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
No new posts Convert Hex to readable format. harpreet_Saini19 DFSORT/ICETOOL 7 Wed Sep 14, 2016 5:46 am
No new posts Variable for cursor names ravikumar15 DB2 5 Sun Jul 17, 2016 7:08 am


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