DSXchange

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.

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.

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.

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

Thank you all for the response.