Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 -502 Error - Cursor already open anand jeyapaul DB2 7 Sun Oct 29, 2017 4:22 am
No new posts Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Default FTP options vasanthz All Other Mainframe Topics 2 Fri Aug 25, 2017 5:58 am
No new posts Default Message in Rexx cvnlynn CLIST & REXX 9 Wed Aug 02, 2017 12:38 am
No new posts Testing rerad cursor for status with ... John F Dutcher DB2 8 Fri May 19, 2017 9:35 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us