DSXchange

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'

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

Export the project and search in the DSX/XML file. Or query the Repository.

Thanks ray,

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.

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.

thanks, chuk

this is of some use.