How to find table name in group of jobs in Datastage

nraj · Post by **nraj** » Thu Jan 12, 2006 6:28 am

Hi

please let us know any commond or search mode to find job name and table name in group of jobs in Datastage

Thanks
Raj

ArndW · Post by **ArndW** » Thu Jan 12, 2006 1:06 pm

Just as with any lookup, you will need to tell us what you are using as the key for your lookup, what criteria. You can use the DataStage command line and a SELECT clause on the DS_JOBS file but the statement depends upon what you want. For instance, you could do a "SELECT DS_JOBS WHERE CATEGORY = '\One\Two'" to show all jobs in that category.

ray.wurlod · Post by **ray.wurlod** » Thu Jan 12, 2006 4:47 pm

Search the forum - you will find a query against DS_JOBOBJECTS and references to at least two (free) third-party utilities. None of them work if your table names are job parameter references.