Page 1 of 1
What jobs are using a flat file?
Posted: Wed Dec 10, 2008 3:55 pm
by 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.
Posted: Wed Dec 10, 2008 4:31 pm
by 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.
Posted: Wed Dec 10, 2008 4:34 pm
by 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!
Posted: Thu Dec 11, 2008 9:19 am
by 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.
Posted: Thu Dec 11, 2008 9:52 am
by 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.