IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Difference between FOR FETCH ONLY, FOR READ ONLY


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
joshkahn

New User


Joined: 30 Dec 2005
Posts: 8

PostPosted: Thu Nov 15, 2007 2:08 am
Reply with quote

What is the difference between FOR FETCH ONLY, FOR READ ONLY, WITH UR.
Back to top
View user's profile Send private message
joshkahn

New User


Joined: 30 Dec 2005
Posts: 8

PostPosted: Thu Nov 15, 2007 2:09 am
Reply with quote

iS THERE A SIMPLE WAY TO GET THE CURRENT WEEKS FRIDAY DATE?
Back to top
View user's profile Send private message
vasanthkumarhb

Active User


Joined: 06 Sep 2007
Posts: 275
Location: Bang,iflex

PostPosted: Thu Nov 15, 2007 11:07 am
Reply with quote

Hi joshkahn,


Quote:
iS THERE A SIMPLE WAY TO GET THE CURRENT WEEKS FRIDAY DATE?


Are you angry with forum,


Fetch only: is used to extract the records from the table.
Read only: means you read the records from the table, but not able to update the record.

UR: is un committed read, which is also called dirty read.

Regard's
Vasanth......... icon_smile.gif
Back to top
View user's profile Send private message
senthilssg

New User


Joined: 09 Dec 2005
Posts: 64
Location: USA

PostPosted: Thu Nov 15, 2007 1:36 pm
Reply with quote

Hi ,

FOR FETCH ONLY or FOR READ ONLY in the DECLARE CURSOR statement
clause is used to indicate that the cursor does not modify data .

Becuase of above defintion , the cursor will be defined as read-only cursor and block fetch is also ensured .

UR :

WITH UR clause can be used at end of SELECT query to avoid the un necessary locks on READ-only database .


Thanks and Regards
Senthil
Back to top
View user's profile Send private message
joshkahn

New User


Joined: 30 Dec 2005
Posts: 8

PostPosted: Thu Nov 15, 2007 7:19 pm
Reply with quote

I still don't understand the difference between FOR FETCH ONLY and FOR READ ONLY. Which is preferred and why?
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Thu Nov 15, 2007 7:42 pm
Reply with quote

joshkahn wrote:
I still don't understand the difference between FOR FETCH ONLY and FOR READ ONLY. Which is preferred and why?


That's because there is no difference.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Random read in ESDS file by using RBA JCL & VSAM 6
No new posts Fetch data from programs execute (dat... DB2 3
No new posts Timestamp difference and its average ... DB2 11
No new posts VSAM return code 23 - for a Random read COBOL Programming 4
Search our Forums:

Back to Top