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

Datacom: what's difference between REDKG and LOCKG&REDLE


IBM Mainframe Forums -> CA Products
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
seman18

New User


Joined: 08 Feb 2009
Posts: 67
Location: hz

PostPosted: Tue Jan 04, 2011 12:52 pm
Reply with quote

REDKG will return the first record which is equal to or greater than key value, however, LOCKG will locate the first record which is equal to or greater than key value as well and REDLE can read the previously located record by LOCKG, so what's the difference between the two approach, can someone explain it? thanks!
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Jan 04, 2011 9:14 pm
Reply with quote

Hello,

The difference is that one locates data for a subsequent read and the other actually reads the data. . .

To locate and read in one interaction with database is (was?) a bit more overhead than the locate alone. However, if one wanted to locate and read, 2 interactions with database were needed.

IIRC, when i first began supporting Datacom (1983), you had to issue both the locate and the read. With a later release, the REDxx implementation occurred.
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 -> CA Products

 


Similar Topics
Topic Forum Replies
No new posts Timestamp difference and its average ... DB2 11
No new posts Difference when accessing dataset in ... JCL & VSAM 7
No new posts What is the difference between Taskty... Compuware & Other Tools 2
No new posts Difference between VALIDPROC and CHEC... DB2 3
No new posts Difference between CEE3250C and CEE3204S COBOL Programming 2
Search our Forums:

Back to Top