You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

How many keys we can have it in a record?

7 replies [Last post]
Hari_aindian's picture
User offline. Last seen 7 years 2 weeks ago. Offline
Joined: 08/02/2010
Posts: 84

How many keys we can have it in a record?

If any one knows pls help me. Also if it is limited to a certain number y is it so?

Regards,
Hari.A

Guest's picture
Guest (not verified)
Re: How many keys we can have it in a record?

Hi SET,

As far as i had seen their is no such limitation to no of fileds or no of key in a perticular record.I had seen a record with 447 field and 19 keys in it.

I am still nt sure about it..It would be better if Lepa or any other guys with that calliber will concrete the same.

Good day......

:)

Hari_aindian's picture
User offline. Last seen 7 years 2 weeks ago. Offline
Joined: 08/02/2010
Posts: 84
Re: How many keys we can have it in a record?

Yes. Still I heard it is limited to 15 keys at the max. But am not sure why is so?
Also I tried to have more than 25 keys in a record. Peopletools allowed to save/build the record.

Executed as create table sql . That also worked out.. Not sure about the max count keys.

Still it's a mystery

:-)

PARITOSH's picture
User offline. Last seen 10 years 13 weeks ago. Offline
Joined: 06/16/2010
Posts: 19
Re: How many keys we can have it in a record?

Hi,

I dont think so their is any limitation on number of key or number of filed in a record for PeopleSoft.

Hari_aindian's picture
User offline. Last seen 7 years 2 weeks ago. Offline
Joined: 08/02/2010
Posts: 84
Re: How many keys we can have it in a record?

In SQL perspective or let say DBMS perspective is there any limitations?

kumar2010's picture
User offline. Last seen 10 years 16 weeks ago. Offline
Joined: 10/26/2010
Posts: 6
Re: How many keys we can have it in a record?

Hi

in peoplebook....
one record is maximum 15keys limitaions.....

vivek6686's picture
User offline. Last seen 10 years 16 weeks ago. Offline
Joined: 09/27/2010
Posts: 8
Re: How many keys we can have it in a record?

"unlimited number of keys"

Hari_aindian's picture
User offline. Last seen 7 years 2 weeks ago. Offline
Joined: 08/02/2010
Posts: 84
Re: How many keys we can have it in a record?

Kumar, Can you pls take snap shot of the Peoplebook. That will be helpful to find where is it exactly?..

Thanks,
Hari.A