DS_JOBOBJECTS: missing info on stages in shared containers

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
Alethesnake
Participant
Posts: 56
Joined: Mon Mar 26, 2007 8:48 am
Location: Blue Bay (La Spezia)

DS_JOBOBJECTS: missing info on stages in shared containers

Post by Alethesnake »

Hi All,

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

Code: Select all

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