You can use the SQL to extract data from the CA 7 database. This sample SQL control statements will list all jobs and its dataset requirements. It will exclude jobs that are marked MAINT=Y.
Release : 12.0, 12.1
Component : CA 7
SELECT SUBSTR(SUCC_OBJECT,1,15) AS JOBNAME,
PRED_OBJECT AS DATASET_REQUIREMENT FROM CA7_REQUIREMENT R,
WHERE R.DB = 'yourlogicaldb' AND
PRED_TYPE = 'DSN' AND
PRED_PERMANENT = 'N' AND
J.DB = R.DB AND
J.JOB = R.SUCC_OBJECT AND
IGNORE_RQMT = 'N'
ORDER BY JOBNAME ;