zOs/SQL/BINDSIM

SELECT *
FROM OA1P.TQZ043BINDGEN G
WHERE G.GENTST > '2015-02-09-11.14.09.613272'
  AND G.RZ = 'RZ2'
  AND G.COM = 'BASELINE_SIMULATION'
AND NOT EXISTS
(SELECT 1
FROM SSXX28Q0.DB2_CATALOGDATA
WHERE DB2TYPE   = 'R'
  AND DB2RZ     = G.RZ
  AND DB2NAME   = G.PGM
  AND LEFT(DB2VERS,10) = LEFT(G.CMPKG,10)
  AND DB2SUBSYS = G.DBSYS
)
;