What jobs are using a flat file?

[tbtcust]

Hi all.

Is it possible to have datastage generate a report that will list all the jobs that use a particulate flat file?

Thanks in advance for any help.

[chulett]

You can query the repository for that and a search for OLETYPE and/or CSeqInput should turn up the previous conversations on the subject.

Or you can just wait for someone to post the query for you.

[jhmckeever]

Code: Select all

SELECT
   DS_JOBS.NAME AS JOB_NAME FMT '40L',
   DS_JOBOBJECTS.OLETYPE AS STAGE_TYPE FMT '40L',
   DS_JOBOBJECTS.NAME AS FILE_NAME FMT '25L'
FROM
   DS_JOBOBJECTS, 
   DS_JOBS
WHERE
   DS_JOBOBJECTS.OBJIDNO = DS_JOBS.JOBNO AND
   DS_JOBOBJECTS.OLETYPE LIKE 'CSeq%';

I had it lying around in my box o' tricks!

[tbtcust]

jhmckeever, thanks for the suggestion. It did not think about querying the underlying database for the answer. I do not see the tables from your query in the xmeta database. I'm guessing the query was for some other version. Thanks again.



chulett, I searched the repository for OLETYPE and found link http://www.anotheritco.com/tools.htm which has a tool called ListFilesAndTablesFromDsx7px written by Chuck Smith. This tool's output is exactly what I need.

[chulett]

I modified a version of Chuck's utility to write the output to a database table so I can query the results. Work'em good.