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
How to find for a particular object
Moderators: chulett, rschirm, roy
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers