|
View previous topic :: View next topic
|
| Author |
Message |
Sowmya Ramachandra
New User
Joined: 11 May 2007
Posts: 20
Location: Canada
|
|
|
|
Hi,
Can anyone let me know whether we can have the primary key of KSDS is any position or the start position of the field should always be 1 ?
Actually my requirement is fetch a record based on key which can have duplicates. Hence I am planning to make that as an Alternate key and make the other feild are the Primary key. I want to avoid an additional sort step change the position of 1st feild.
Regards,
Sowmya |
|
| Back to top |
|
 |
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA
|
|
|
|
| Primary key of a KSDS does not have to start in the first byte. |
|
| Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
| Sowmya Ramachandra wrote: |
| Can anyone let me know whether we can have the primary key of KSDS is any position or the start position of the field should always be 1 ? |
No, why would you think it needs to be?
| Quote: |
| Actually my requirement is fetch a record based on key which can have duplicates. Hence I am planning to make that as an Alternate key and make the other feild are the Primary key. I want to avoid an additional sort step change the position of 1st feild. |
Normal loads require the primary key to be in sequence, but a program updating/inserting could handle the non-sequential primary key...... |
|
| Back to top |
|
|
Sowmya Ramachandra
New User
Joined: 11 May 2007
Posts: 20
Location: Canada
|
|
|
|
I could see most of the times the Primary key was starting from 1st byte  .. anyways thanks for your response |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| I could see most of the times the Primary key was starting from 1st byte |
Yup, this is for the sake of people rather than the computer  |
|
| Back to top |
|
|
|
|
