How To find list of Datastage jobs using a LookupFileset ?
Posted: Thu Jul 10, 2014 7:28 am
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
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