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
 

 

Advantage of Updating record using Db key instead of CALC

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IDMS/ADSO
View previous topic :: :: View next topic  
Author Message
Shaheen Kalokhe

New User


Joined: 21 Feb 2008
Posts: 21
Location: India

PostPosted: Thu Feb 21, 2008 6:07 pm    Post subject: Advantage of Updating record using Db key instead of CALC
Reply with quote

Hello,

I would like to know the advantage of Updating a record using its DB Key
instead of CALC key. Does anyone has any idea of the time saved by using Db key based updates.

Thanks

Shaheen
Back to top
View user's profile Send private message

puviarasu

New User


Joined: 10 Mar 2008
Posts: 4
Location: India

PostPosted: Tue Mar 11, 2008 7:13 pm    Post subject: Using DB-KEY is advantageous
Reply with quote

Updating a record using DB-KEY is advantageous since the DB-KEY is the address of the particular record. Its the Page number + line number of that record. So if you try to update a record using the DB-KEY it will locate the record using this key value which is straight forward.

But when u update the same record using the CALC key, it should locate the record based on the calcing logic... which might require few more operations and consume more CPU time... which will be slightly slower than the first one...
Back to top
View user's profile Send private message
Shaheen Kalokhe

New User


Joined: 21 Feb 2008
Posts: 21
Location: India

PostPosted: Tue Mar 11, 2008 9:14 pm    Post subject: Re: Using DB-KEY is advantageous
Reply with quote

Thanks for uri reply puviarasu

But what exactly i am looking for is the time difference. I already know that update using DB-Key is efficient. If ua have some details pertaining to time pals do reply.

Thanks

Shaheen
Back to top
View user's profile Send private message
puviarasu

New User


Joined: 10 Mar 2008
Posts: 4
Location: India

PostPosted: Tue Mar 11, 2008 9:46 pm    Post subject: Regarding Time Difference
Reply with quote

I don't have the detail regarding the time difference for this particular scenario. I can suggest one thing while coding a batch program we can retrieve the TIMESTAMP before and after the execution of the DML statements(bulk) using the DB-KEY/CALC-KEY which might give the time difference.
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 -> IDMS/ADSO All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm
No new posts Sort Large record length cmsmoon DFSORT/ICETOOL 14 Tue Apr 11, 2017 5:49 pm
No new posts Format record to remove Leading zeroes Learncoholic DFSORT/ICETOOL 14 Wed Apr 05, 2017 2:43 pm
No new posts Record Not found in AlX but record re... mukun264 COBOL Programming 7 Fri Mar 24, 2017 9:28 am


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