Querying for Source and Target Table Names

SGT · Post by **SGT** » Fri Jun 18, 2004 12:20 pm

Given a particular job name, from the Datastage repository can I query(from Administrator or otherwise) to find out what is the source and target table names used in the Job.
Assumption is that I use only one source and target table and I use the Dynamic RDBMS stage for both.
(If not familiar with Dynamic RDBMS stage can also give solution considering I was using ODBC stage)
Thanks.
SGT

kduke · Post by **kduke** » Fri Jun 18, 2004 4:00 pm

No you cannot unless you know a lot about DS_JOBJECTS and Universe. You need MetaStage or query against the doc_tool.mdb that is populated by the Reporting Assistant.

ray.wurlod · Post by **ray.wurlod** » Fri Jun 18, 2004 5:55 pm

And, if you've used job parameters for table names, this can be quite a messy query!

The table name is a property of the passive stage's input or output link. So, given a job name, you need to determine a list of that job's stage names (from DSStages Where JobName = 'name'). Then you need to determine the link names connected to stages (from DSLinks joined to those rows in DSStages). Then you need to determine which links connect to which table names (from DSProperties joined to those rows from DSLinks). If they're parameters, you then have the parameter name(s) and have to join also to DSParameters and from there back to DSProperties to get the table names. Enjoy! Or get MetaStage, when it does the work for you.

mandyli · Post by **mandyli** » Sat Jun 19, 2004 5:36 am

Hi

If u using ODBC stageu can view the source and target table from OBDC stage itself..

Please check the ODBC stage.