DSXchange

Posted: **Sun Mar 15, 2020 12:44 pm**

Hi All,

I am using the following query against localuv in order to find all jobs that use a specific table:

SELECT 
    DS_JOBS.NAME
    , DS_JOBS.CATEGORY
    , DS_JOBOBJECTS.NAME
    , DS_JOBOBJECTS.OLETYPE
    , EVAL DS_JOBOBJECTS."if index(upcase(@RECORD),upcase('#TableName#'),1) > 0 then 'FOUND' else ''" AS FOUND FMT '5L' 
FROM 
    DS_JOBOBJECTS, DS_JOBS 
WHERE 
    DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO 
    and 
    FOUND = 'FOUND'  
    and 
    DS_JOBOBJECTS.OLETYPE='CCustomStage' 
GROUP BY 
    DS_JOBS.NAME
    , DS_JOBS.CATEGORY
    , DS_JOBOBJECTS.NAME
    , DS_JOBOBJECTS.OLETYPE
    , FOUND
;

It works fine except when the db connector is not directly inside the job but inside a shared container referenced by the job.
In this case no rows are returned.

Is there any workaround to this (or is there a mistake in the query)?

I read this APAR regarding lineage in version 11.5, is auspicable to suppose that the issue affects also our version and it is responsible for the problem?

Thanks in advance,

Alessandro.

DSXchange

DS_JOBOBJECTS: missing info on stages in shared containers

DS_JOBOBJECTS: missing info on stages in shared containers