To find columns in the project

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
srini.dw
Premium Member
Premium Member
Posts: 186
Joined: Fri Aug 18, 2006 1:59 am
Location: Chennai

To find columns in the project

Post by srini.dw »

Hi,

In a project i have 400 jobs, in that I have a table i.e., I08_TBL, In one of the V15_TBL we have used the I08 table as the lookup, for some reason we need to change the I08 table, how to find out all the jobs which is using I08 key and code columns in the project.

Plz let me know the solution, i have tried Usage analysis, not able to find out.

thank you
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Use the query in thispost.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
srini.dw
Premium Member
Premium Member
Posts: 186
Joined: Fri Aug 18, 2006 1:59 am
Location: Chennai

Post by srini.dw »

Thank you, that query is working
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Just don't expect it to work after you upgrade to version 8.0 or later.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply