A new version of my List all files and tables tool...

[chucksmith]

Hi,

I just posted version 7px.b of my List all files and tables used by jobs in a dsx file.

This version does a much better job (1) connecting the link and stage properties, (2) extracting table information from database stages, (3) parsing SQL statements (the older versions did not do it at all), and (4) normalizing table names from database stages that include joins.

It handles server jobs very well, but I have not tested it thoroughly with parallel jobs, but it should handle your basic needs.

As always, you will find this and other tools on the DataStage Tools page of www.anotheritco.com.

Happy 2011,

[chulett]

Thanks Chuck.