How to find for a particular object

vij · Post by **vij** » Mon Jan 04, 2010 3:22 pm

Hi,

How do I find/look for a particular object in datastage jobs- eg., how can find the list of jobs that uses a table called EMP or a file called EMP.txt?

Please help me find this- this will help me avoid opening all the 200 datstage jobs we have in our project.

Thanks,
Vij

chulett · Post by **chulett** » Mon Jan 04, 2010 3:31 pm

Several ways. Export the project and search the dsx file. Use the dsx file with something like what Chuck Smith has posted. Search the forums for queries mentioning OLETYPE for examples of how to directly query the repository. And if you've been good about leveraging metadata, you can use the Usage Analysis tool from the Manager on your saved table / file metadata.

vij · Post by **vij** » Mon Jan 04, 2010 3:59 pm

Thanks Chulett, it was useful.