Wednesday, June 15, 2011

Where is it?


This might be a duplicate information for many, but I believe some one is going to get benefitted from this once again.

The PeopleCode is stored in PSPCMPROG, which has all the PC objects details. If you want to quickly check the existance of your application engine program codes, the issue the SQL against this table.

SELECT * FROM PSPCMPROG WHERE OBJECTVALUE7 LIKE 'OnExecute%'

PSSQLTEXTDEFN: Contains all SQL objects in the database.
SELECT * FROM PSSQLTEXTDEFN WHERE SQLID like '%Step%'

0 comments:

Post a Comment

Total Pageviews

Copyright © Tech & Management Notes