I need to find out datasets used in a DataStage project.
Code: Select all
>SELECT @ID FROM DS_STAGETYPES WHERE @ID LIKE '%PxDataSet%';
DS_STAGETYPES
PxDataSet
Code: Select all
>SELECT DISTINCT DS_JOBS.NAME JobName, DS_JOBOBJECTS.NAME StageName FMT
'48L' FROM DS_JOBS, DS_JOBOB
JECTS WHERE DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO AND DS_JOBOBJECTS.
OLETYPE LIKE '%PxDataSet%' AND D
S_JOBS.JOBTYPEIND LIKE '3' ORDER BY 1, 2 ;
0 records listed.
Appreciate if someone can help.
Thanks