Hi
Is there a command like dsjobs -lstages to find out what all datasets are used in a patricular job.
Example : If job A has 3 data sets a,b,c
output of command be like
Job A a
Job A b
Job A c
Thanks in advance
Datasets for a job
Moderators: chulett, rschirm, roy
There is no functionality to do this straight out of the box, particularly from the command line. One option is to do a full project export into a .dsx and then to use a tool such as sed or awk to parse out the relevant job names and datasets; that won't take much effort.
<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:
-
- Participant
- Posts: 334
- Joined: Fri Dec 01, 2006 5:17 am
- Location: Texas
Hi,
You can query the Datastage Database...
With help of DS Gurus.....i have created the query.....but not able to test it right now...
Hope this will help you out...
You can query the Datastage Database...
With help of DS Gurus.....i have created the query.....but not able to test it right now...
Hope this will help you out...
Code: Select all
SELECT
DS_JOBS.NAME FMT '50L'AS JOB_NAME,
EVAL DS_JOBOBJECTS."@RECORD<15,1>" AS DATASET_NAME
FROM
DS_JOBS,
DS_JOBOBJECTS
WHERE
DS_JOBS.JOBNO=DS_JOBOBJECTS.OBJINO
GROUP BY
JOB_NAME,
DATASET_NAME
http://findingjobsindatastage.blogspot.com/
Theory is when you know all and nothing works. Practice is when all works and nobody knows why. In this case we have put together theory and practice: nothing works. and nobody knows why! (Albert Einstein)
Theory is when you know all and nothing works. Practice is when all works and nobody knows why. In this case we have put together theory and practice: nothing works. and nobody knows why! (Albert Einstein)