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

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