DSXchange

I need to find out the inputs and outputs (tables, hash file, sequential files) for all the jobs in a category. Though I know how to make a list of jobs in category by querying the DS_JOBS, I can't find a way to get the next step, i.e., getting the inputs and outputs details.

I would appreciate any help.

Thanks.

Hash files and sequential files can be listed from DS_JOBOBJECTS. Do a search. The other you need MetaStage, Reporting Assistant or DwNav.

You could also check out Chuck Smith's utilities: http://www.anotheritco.com/tools.htm

In particular the 'List all files and tables used by jobs in a dsx file' tool, aka DataStage job.