I am using the following query against localuv in order to find all jobs that use a specific table:
Code: Select all
, EVAL DS_JOBOBJECTS."if index(upcase(@RECORD),upcase('#TableName#'),1) > 0 then 'FOUND' else ''" AS FOUND FMT '5L'
DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO
FOUND = '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,