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

What is meant by Atomic Key in DB2
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
Jeevanand
Warnings : 1
New User


Joined: 26 Dec 2006
Posts: 4
Location: Coimbatore
PostPosted: Thu Mar 29, 2007 2:56 pm
 Reply with quote
What is meant by Atomic Key in DB2?
Back to top
View user's profile Send private message
vini_srcna

Active User


Joined: 26 May 2005
Posts: 178
Location: Copenhagen, Denmark
PostPosted: Thu Mar 29, 2007 6:24 pm
 Reply with quote
I dont think its a DB2 concept. May i know where you referred to it.
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: Thu Mar 29, 2007 9:19 pm
 Reply with quote
Hello,

In DB2 (and many other databases) an Atomic Key is simply "something" that cannot be broken into meaningful lower components. It consists of only one field. Department_No could be an atomic key for the department table.
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 What is meant by UNIT=DPERM? JCL & VSAM 7
No new posts What is meant by Wtr in SDSF? All Other Mainframe Topics 1
No new posts What is meant by SLOC count? All Other Mainframe Topics 7
No new posts What is meant by "NEXT-RUN=YES&q... CA Products 2
No new posts What is meant by SKELETON in CA-7? CA Products 3
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