Finding the jobs that use a field in a hash file

SonShe · Post by **SonShe** » Thu Nov 10, 2005 2:41 pm

When a column is dropped from a hash file and the hash file is being used in many jobs, I would like to know if the column definition has been modified in all the jobs. I will appreciate a lot if any one can help me or give me any idea how I can get this detail.

Thanks.

vmcburney · Post by **vmcburney** » Thu Nov 10, 2005 5:59 pm

Have a look at the FAQ on DataStage reporting options. Probably the easiest way is to load up the DataStage Reporting Assistant and write your own query to retrieve all jobs using that column.

ray.wurlod · Post by **ray.wurlod** » Fri Nov 11, 2005 3:41 am

If you've been punctilious with maintaining the link between the table definition in the Repository and the Hashed File stages in all jobs (that is, always loading from or saving to the Repository), then you should be able to use Usage Analysis in the Manager to show you the jobs in which that table definition is used. Right click on each job in turn and choose Locate in Manager to select that particular job - this way you don't have to worry what category it is in - DataStage will find it for you.

kduke · Post by **kduke** » Fri Nov 11, 2005 6:42 am

Ray only developers down under are punctilious or are the only ones who would admit to it.

SonShe · Post by **SonShe** » Fri Nov 11, 2005 12:47 pm

Thank you all for the response.