Can I Use XMETA to list all hashed file names?

gsbrown · Post by **gsbrown** » Thu Oct 29, 2015 2:29 pm

Is there an XMETA repository query that can give me a unique list of all hashed tables referenced in hashed stages across all of our DataStage jobs? Or maybe an alternate method? I want to exclude system hashed tables, only hashed files put into the "File Name" field in hashed file stages

ray.wurlod · Post by **ray.wurlod** » Thu Oct 29, 2015 9:18 pm

Probably. Though it would be far simpler to query DS_JOBOBJECTS.

In either case, the query will not be able to resolve job parameter references without being a lot more complex.

chulett · Post by **chulett** » Thu Oct 29, 2015 9:46 pm

I've had good luck in the past with queries of this nature before there was an XMETA database by leveraging some of Chuck Smith's tools. Specifically the List all files and tables used by jobs in a dsx file modified to load the results into a table so I could query them easily. Yes, it's a bit old school and you need to feed it a dsx export of the project but it does work nicely and I've used it to get exactly the kind of information you are looking for, classified by source or target if desired.

Alternate method.