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

Which is the best READ for this scenario?
IBM Mainframe Forums -> Java & MQSeries
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
cooolguyin
Warnings : 1
New User


Joined: 12 May 2005
Posts: 10
Location: NY
PostPosted: Thu Jan 27, 2011 9:55 am
 Reply with quote
Hi,

If i want to read and update ALL the records in a adabas file then which of the following READ is efficient and why

READ PHYSICAL

READ BY ISN

READ BY LOGICAL

Thanks...
Back to top
View user's profile Send private message
Ats

New User


Joined: 21 Jul 2010
Posts: 6
Location: Roaming
PostPosted: Thu Jan 27, 2011 3:57 pm
 Reply with quote
Well, it depends on data and different situations. All of them can be used for mass update.

READ PHYSICAL - Generally least expensive method to read all records however, potential double updates could be a problem

READ BY ISN - ISN use ensures no double updates & no missed updates

READ LOGICAL - Need to be careful when updating read key fields
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 -> Java & MQSeries

 

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 VSAM return code 23 - for a Random read COBOL Programming 4
No new posts ICETOOL to Read records SMF CEF it is... DFSORT/ICETOOL 4
No new posts EMPTY file check scenario JCL & VSAM 6
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us