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.
What jobs are using a flat file?
Moderators: chulett, rschirm, roy
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.
Or you can just wait for someone to post the query for you.
Last edited by chulett on Wed Dec 10, 2008 5:01 pm, edited 1 time in total.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 301
- Joined: Thu Jul 14, 2005 10:27 am
- Location: Melbourne, Australia
- Contact:
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%';
<b>John McKeever</b>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
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 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.