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.

temp tables and field datatypes

3 replies [Last post]
gwulfwud's picture
User offline. Last seen 10 years 26 weeks ago. Offline
Joined: 05/07/2009
Posts: 7

hey guys,

i have a clarification, what is the difference between derived and temporary records? both of them doesn't have rows on the database correct? but can you put some PC on temp records or is it only applicable to derived records?

also, what are the datatypes that are available when creating a field on peopletools?

thanks!
-g

Lepa's picture
User offline. Last seen 2 years 20 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: temp tables and field datatypes

To know more about temp tables please check out the attached doucment on this post.

Quote:
also, what are the datatypes that are available when creating a field on peopletools?

I think your answer is here :)

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

maripaka's picture
User offline. Last seen 9 years 27 weeks ago. Offline
Joined: 12/08/2008
Posts: 3
Re: temp tables and field datatypes

The above post answers the query. Briefly put, the significant difference between temporary and the derived records is that the Derived record is not a Database object. It cannot have a physical database table. It cannot be 'built'

Whereas temporary table will have a physical table 'built' in the database. But the proceses like Application Engine clears them once the process is over. Also there can be multiple versions created and maintained for a single Temporary table to handle concurrency and avoid locking of the tables.

Regards,
Rao.

Regards,
Mutyala Rao

gwulfwud's picture
User offline. Last seen 10 years 26 weeks ago. Offline
Joined: 05/07/2009
Posts: 7
Re: temp tables and field datatypes

Thank you for the replies. It really helped!