Can we find all the job names, which use a specific dataset.
sth like(for job name)
SELECT CATEGORY FROM DS_JOBS WHERE NAME = 'JobSeq_Prod'
Can we find all the job names, which use a specific dataset.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 334
- Joined: Fri Dec 01, 2006 5:17 am
- Location: Texas
You can get this in the following link:
viewtopic.php?t=115460&highlight=
This link is quite similar to your question...
If your stage name is same to your dataset name..then you can use a tidious method....that is writing script which will use most of the commands from "dsjob"
If the above conditions (stagename in job= dataset name) and if you want i will develop the script and will give it to you...
Waiting for DSGurus suggestions......
viewtopic.php?t=115460&highlight=
This link is quite similar to your question...
If your stage name is same to your dataset name..then you can use a tidious method....that is writing script which will use most of the commands from "dsjob"
If the above conditions (stagename in job= dataset name) and if you want i will develop the script and will give it to you...
Waiting for DSGurus suggestions......
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Export the project and search in the DSX/XML file. Or query the Repository.
Code: Select all
SELECT NAME FMT '40L' FROM DS_JOBS
WHERE JOBNO IN (
SELECT OBJIDNO FROM DS_JOBOBJECTS
WHERE OLETYPE = 'CCustomInput'
AND EVAL "@RECORD<14,1>" = 'dataset'
AND EVAL "@RECORD<15,1>" LIKE '%<<Data Set name>>'
) ;
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.
Thanks ray,
ray,
Can you guide me on the DataStage Repository(what is the table description of DS_JOBS, what key info each column holds ) and few other tables which hold key information.
to some, me to a doc/pdf or sth,
thanks to anyone who can answer.
ray.wurlod wrote:Code: Select all
SELECT NAME FMT '40L' FROM DS_JOBS WHERE JOBNO IN ( SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE OLETYPE = 'CCustomInput' AND EVAL "@RECORD<14,1>" = 'dataset' AND EVAL "@RECORD<15,1>" LIKE '%<<Data Set name>>' ) ;
ray,
Can you guide me on the DataStage Repository(what is the table description of DS_JOBS, what key info each column holds ) and few other tables which hold key information.
to some, me to a doc/pdf or sth,
thanks to anyone who can answer.
These internal tables (actually, hashed files) are not officially documented anywhere. If you look thorugh this site you will find some references and descriptions - more than you would get from Ascential/IBM.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
Try my List all files and tables used by jobs and routines in a dsx file. You will find it on the DataStage Tools page of www.anotheritco.com .
It understands all server passive stages, and has limited understanding of the following parallel stages: SequentialFile, FileSet, DataSet, LookupFileSet, sqlsvr, DRS, andOracle.
It understands all server passive stages, and has limited understanding of the following parallel stages: SequentialFile, FileSet, DataSet, LookupFileSet, sqlsvr, DRS, andOracle.
Chuck Smith
www.anotheritco.com
www.anotheritco.com