Finding a Input Dataset used in jobs
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3
- Joined: Tue Oct 02, 2007 5:04 am
Finding a Input Dataset used in jobs
How do i find all the job names that may be using a specific dataset easily, without having to go through each job to find out what inputs it is using in datastage.
Any kind of help will be appreciated.
Any kind of help will be appreciated.
M-B
Use the following query at the uv account or admin command, once logged into your project.
Put in your dataset name where it says 'FIND ME'. Use it and Thank Kim Duke. Its his code.
Code: Select all
SELECT
DISTINCT DS_JOBS.NAME AS JOB_NAME FMT '100L',
DS_JOBS.CATEGORY FMT '100L',
DS_JOBOBJECTS.NAME AS OBJECT_NAME FMT '100L',
DS_JOBOBJECTS.OLETYPE FMT '100L',
EVAL DS_JOBOBJECTS."if index(@RECORD,'FIND ME',1) > 0 then 'FOUND' else ''" AS FOUND FMT '5L'
FROM
DS_JOBS,
DS_JOBOBJECTS
WHERE
DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO
and FOUND = 'FOUND'
GROUP BY
JOB_NAME,
DS_JOBS.CATEGORY,
OBJECT_NAME,
DS_JOBOBJECTS.OLETYPE,
FOUND
;
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 3
- Joined: Tue Oct 02, 2007 5:04 am
If your dataset name is in a job parameter, then this method won't work - you would need to do a more complex search. On the other hand, if you know the parameter name you could search for that.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This is not a suitable answer for version 7.x. Also it would not work in the UV account.DSguru2B wrote:Use the following query at the uv account or admin command, once logged into your project.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: