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

Possibility of having more than one primary key


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Query on edit primary command CLIST & REXX 5
No new posts Query on edit primary command CLIST & REXX 1
No new posts Cobol prog to put an indicator on the... JCL & VSAM 1
No new posts Can we Insert duplicates in Primary U... DB2 2
No new posts SFTP to primary and secondary servers JCL & VSAM 4
Search our Forums:

Back to Top