zOs/SQL/UCK04001

-- EXPLAIN  PLAN SET QUERYNO = 201 FOR
SELECT CK040001,CK040002,CK040005,CK040006,CK040008,CK040009,CK040010,
       CK040011,CK040021,CK040022,CK040031,CK040032,CK040033,CK040034,
       CK040035,CK040036,CK040037,CK040038,CK040039,CK040040,CK040041,
       CK040042,CK040043,CK040044,CK040045,CK040046,CK040047,CD600016
FROM OA1T.TCK040A1, OA1T.TCD600A1
WHERE SUBSTR(CK040033,1,16) = CD600001
  AND ( 0 = 1 OR
    ( CK040032 = ''
  AND CD600005 < CURRENT TIMESTAMP
  AND CD600006 > CURRENT TIMESTAMP
  AND CK040005 < CURRENT TIMESTAMP
  AND CK040006 > CURRENT TIMESTAMP
  ) )
UNION ALL
SELECT CK040001,CK040002,CK040005,CK040006,CK040008,CK040009,CK040010,
       CK040011,CK040021,CK040022,CK040031,CK040032,CK040033,CK040034,
       CK040035,CK040036,CK040037,CK040038,CK040039,CK040040,CK040041,
       CK040042,CK040043,CK040044,CK040045,CK040046,CK040047,CD100001
FROM OA1T.TCK040A1, OA1T.TCD100A1
WHERE CK040032 = CD100002
  AND CK040032 <> ''
  AND CK040005 < CURRENT TIMESTAMP
  AND CK040006 > CURRENT TIMESTAMP
WITH UR