Is there any way of getting the list of tables used in a job

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
pg_smh
Participant
Posts: 15
Joined: Sat Feb 10, 2007 3:31 am

Is there any way of getting the list of tables used in a job

Post by pg_smh »

Hi, is there any way of getting the list of tables used as source DRS, lookups and target DRS in the ETL job.
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Yes, there are several ways. The most commonly-posted involve querying the DS_JOBOBJECTS table constraining on OLETYPE. Search the forum for details. Chuck Smith has a utility for identifying hashed files that could be adapted.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “General”