Routine Sql to list all jobs linked to specific table-fails

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

cundyp
Premium Member
Premium Member
Posts: 53
Joined: Tue Feb 06, 2007 10:57 am

Post by cundyp »

Both of these suggested options worked!

NOTE: I replaced tablename with filename and all the jobs using that specific file were listed.

I have turned the GTAR (AS FOUND) problem into IBM but they have not provided a case number. (This is an internal problem with DataStage/SQL (GTAR = general technical assistance request)).

This subject can be closed out.

Thank you for all your help and patience in resolving this issue.
Pete Cundy
Leawood, Kansas
Post Reply