How To find list of Datastage jobs using a LookupFileset ?

[Rajesh Jale]

Hi,

May I know how should I fetch the list of datastage jobs in a project which are using a Lookupfileset (Eg : Name of the lookupfileset : Customer_Records_Ref)

I have referred some old posts which are related to the table..i.e.. getting list of datastage jobs which are using a table. But i am unable to fetch this with the same query. Can anyone help me with the relavent query.

Query for table :
SELECT DS_JOBS.NAME AS JOB_NAME,DS_JOBS.CATEGORY,DS_JOBOBJECTS.NAME AS OBJECT_NAME,DS_JOBOBJECTS.OLETYPE,EVAL DS_JOBOBJECTS."if index(@RECORD,'TABLE_NAME',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;

Regars,
Rajesh

[kduke]

I would use dsjob -ljobs >filelist.txt

[ray.wurlod]

Right click on Lookup File Set in Palette and perform a Where Used search.