Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Possibility of having more than one primary key

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
edwin

New User


Joined: 27 Apr 2005
Posts: 4

PostPosted: Mon May 02, 2005 8:03 pm    Post subject: Possibility of having more than one primary key
Reply with quote

Hi friends,

Is there any possibility of having more than one primary key in a single table.
Back to top
View user's profile Send private message

vijayamadhuri

Active User


Joined: 06 Apr 2005
Posts: 180

PostPosted: Mon May 02, 2005 9:55 pm    Post subject: Hi
Reply with quote

It is not possible to have have more than one primary key for the table as the PRIMARY KEY defined for the table is UNIQUE and the uniqueness of the table is retained by the PRIMARY KEY.
Back to top
View user's profile Send private message
priya

Moderator


Joined: 24 Jul 2003
Posts: 568
Location: Bangalore

PostPosted: Wed May 04, 2005 7:24 am    Post subject:
Reply with quote

Dear Edwin, Do you mean Partial Keys?
Back to top
View user's profile Send private message
kanak

Moderator


Joined: 12 Mar 2005
Posts: 252
Location: India

PostPosted: Wed May 04, 2005 3:29 pm    Post subject:
Reply with quote

no more than one primary key is not possible...ya but composite keys are possible where two or more than two field can create a unique value.
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SFTP to primary and secondary servers mallik4u JCL & VSAM 4 Tue Jun 07, 2016 12:52 pm
No new posts Count unique values in a column based... Deepakgoyal2005 JCL & VSAM 4 Fri Jul 25, 2014 5:49 pm
No new posts Skipping secondary record when primar... magesh23586 DFSORT/ICETOOL 8 Sat Dec 07, 2013 11:41 pm
No new posts XRC side effect On Primary site. Manshadi JCL & VSAM 2 Wed Feb 27, 2013 5:31 pm
No new posts how to know primary key in a table? NAARAAYANAN JCL & VSAM 4 Wed Sep 26, 2012 4:18 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us