DSXchange

Hi,


I want to see all the job names, whether a partincular table has been used. i need this to be done through the Command window in the Administrator, instead of using Usage Analysis.

Can any one help me in this.

I don't think that it can be done in the command window in Administrator. In order to do that you need to be an expert in universe and you should know the metadata of internal table structures of universe which is not available to public. Also it is quite hard to understand the structures if you are new to universe.

For the moment Usage Analysis and Reporting tool comes along with datastage is the only option where you can look your answer. There is another product called Metastage by Ascential which is meant for metadata.

Thanks
Siva

Your request is impossible. You're asking for a single command to parse the job design repository to find all usage of a table name. Searching the table definitions for using in the job designs is a broken search method, this trick doesn't work (see MetaStage user complaints).

What you want could be achieved only programmatically.

That sounds like a challenge!

It would be a particularly horrible SQL query, and probably end up exceeding the maximum permissible length for a query statement. Even if you knew the internal structure for records in the DataStage Repository.

And if you use job parameters for table names, the problem worsens by one or two orders of magnitude.

Theoretically, though, it could be done.

But not by this little black duck!

rajiivnb wrote:Hi,


I want to see all the job names, whether a partincular table has been used. i need this to be done through the Command window in the Administrator, instead of using Usage Analysis.

Can any one help me in this.

thanx for ur quick response.

If you could limit it to specific stage types then it is possible. Ray posted one for hash files. What stage types do you need?

Otherwise buy DwNav. That is why I wrote it.