Thursday, December 22, 2005

Extract PeopleCode

If you want to create a file that contains all the PeopleCode for a project (or database) you can use the Find In. . .feature, and search for ";". Be sure to select Save PeopleCode to File. (Do not use double quotes).

6 comments:

ChiDONEt said...

Do you Know in wich table is save the PeopleCode ??? I thinking that is in PSPCMPROG. Dou you have any idea ?

ChiDONEt said...

Do you Know in wich table is save the PeopleCode ??? I thinking that is in PSPCMPROG. Dou you have any idea ?

Ketan Kothari said...

Yes it is stored in PSPCMPROG and PSPCMNAME. However it is stored in binary format and you can not extract using SQL Query tool for your DB.

Unknown said...

hi ketan,
could you pls. help me on this..
if the people code stored in the PSPCMPROJ cannot accesed by SQL then could u tell me the way to acess the people code, since we are planing to write SQR to retrive all PC associated with a component.

Ketan Kothari said...

Easiest way to do this is create a project in app designer and insert all peoplecode into this project for this component. Once done use Find In peoplecode method for this project using ; , you can extract everything to a file.

bicyclist22 said...

PSPCMPROG.PROGTXT contains PeopleCode.
PSSQLTEXTDEFN.SQLTEXT contains SQL.

Read David L. Price's blog and www.passportgeek.com for more info.