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.

data stage

5 replies [Last post]
kittu's picture
User offline. Last seen 8 years 7 weeks ago. Offline
Joined: 03/05/2011
Posts: 7

we have a record.now i want to find out the jobs that are using particular record in data stage(for example ps_job)

Hari_aindian's picture
User offline. Last seen 5 years 18 weeks ago. Offline
Joined: 08/02/2010
Posts: 84
Re: data stage

to find out the jobs - means Application engines?

If it is application engines we can sort out easily. We have a delivered record which will hold all the sql definitions resides in a app engine. I think PSAESTMTDEFN is the record. this rec will have AE_APPLID - Application engine name, SQLID - Sqls. you can query the sqltextdefn rec to find out what are the sqls using your rec. Then u can query this PSAESTMTDEFN record to find out the job.

Ashar's picture
User offline. Last seen 3 years 17 weeks ago. Offline
Joined: 03/26/2008
Posts: 227
Re: data stage

I think it is going to be a tough job. What if developer had used the record in PeopleCode? and how about SQRs? There are different possibilities of using the record in jobs. Please be specific in your question.

Lepa's picture
User offline. Last seen 36 weeks 1 day ago. Offline
Joined: 06/23/2008
Posts: 591
Re: data stage

There is a delivered SQR that you can use to gets records and how they are used in AEs, SQRs, and Cobol. I can't remember the sqr name right at this moment but i've used it before. It outputs tables used in the programs and the action taken on them, like insert, update, delete and so on.

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

Ashar's picture
User offline. Last seen 3 years 17 weeks ago. Offline
Joined: 03/26/2008
Posts: 227
Re: data stage

Thats good to know.. lets know when you find out the name of the SQR.

Lepa's picture
User offline. Last seen 36 weeks 1 day ago. Offline
Joined: 06/23/2008
Posts: 591
Re: data stage

Ashar, the sqr name is tblusage.sqr

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