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.![Wink :wink:](./images/smilies/icon_wink.gif)
Or you can just wait for someone to post the query for you.
![Wink :wink:](./images/smilies/icon_wink.gif)
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.