Ask Question
Help Others
Home › Forums › PeopleSoft › PeopleSoft Technical

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]
Thu, 08/26/2010 - 1:00am
Hari_aindian's picture
Hari_aindian
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

Bookmark/Search this post with
  • Buzz Up!
  • del.icio.us
  • Digg
  • Facebook
  • Google Buzz
  • Reddit
  • StumbleUpon
  • Technorati
  • Twitter
  • Yahoo
Top
  • Login to post comments
  • 3433 reads
Thu, 08/26/2010 - 5:11am
#1
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......

:)

Top
Thu, 08/26/2010 - 6:22am
#2
Hari_aindian's picture
Hari_aindian
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

:-)

Top
Fri, 08/27/2010 - 5:35am
#3
PARITOSH's picture
PARITOSH
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.

Top
Fri, 08/27/2010 - 6:03am
#4
Hari_aindian's picture
Hari_aindian
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?

Top
Wed, 10/27/2010 - 3:59am
#5
kumar2010's picture
kumar2010
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.....

Top
Thu, 10/28/2010 - 5:50am
#6
vivek6686's picture
vivek6686
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"

Top
Fri, 10/29/2010 - 2:02am
#7
Hari_aindian's picture
Hari_aindian
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

Top