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
;
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.