Datasets for a job

[nishtala]

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

[ArndW]

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.

[nishtala]

Thanks for the reply ...

it seems a long way I was hoping to see some ORCHADMIN command or some thing like that...

I will check more options if you know any shorter way plaese let us know...

Thanks

[ray.wurlod]

Just look at the generated OSH or, even better, the score.

[AmeyJoshi14]

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...

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