zOs/SQL/REIST

select  (hour(current timestamp) * 60 + minute(current timestamp)) * 60
        + second(current timestamp),
        current timestamp, 'tst anfang'
    from sysibm.sysdummy1
;
SELECT FI.FI_ID,
       FI.FI_Status,
       PI.Auftrags_Nummer,
       FI.TimerTyp,
       FI.Ausloese_Zeitpunkt,
       MP.ED_Kurzname,
       FA.FD_Name,
       PM.PM_Name
FROM   oa1t.VPW311A1V FI,
       oa1t.VPW310A1V PI,
       oa1t.VPW301A1V PM,
       oa1t.VPW302A1V FA,
       oa1t.VPW318A1V MP
WHERE  FI.Laufzeit           =  0
  AND  FI.TimerTyp         like '%%%%'
  AND  FI.Ausloese_Zeitpunkt >= '2006-10-16-16.39.13.817263'
  AND  FI.Ausloese_Zeitpunkt <= '9999-12-31-23.59.59.999999'
  AND  FI.FI_STATUS        like '%'
  AND  PI.Auftrags_Nummer  like '%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%'
  AND  PI.PI_Status          <> 'B'
  AND  PM.PM_Name like '%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%'
  AND  PI.PI_ID              =   FI.PI_ID
  AND  PI.PM_ID              =   PM.PM_ID
  AND  PM.EntryType          =  'R '
  AND  FI.MP_ID              =   MP.MP_ID
  AND  FI.FA_ID              =   FA.FA_ID
  AND  FA.EntryType          =  'R '
ORDER BY FI.Ausloese_Zeitpunkt ASC
;
select  (hour(current timestamp) * 60 + minute(current timestamp)) * 60
        + second(current timestamp),
        current timestamp, 'tst nach leer'
    from sysibm.sysdummy1
;
SELECT FI.FI_ID,
       FI.FI_Status,
       PI.Auftrags_Nummer,
       FI.TimerTyp,
       FI.Ausloese_Zeitpunkt,
       MP.ED_Kurzname,
       FA.FD_Name,
       PM.PM_Name
FROM   oa1t.vpw311A1V FI,
       oa1t.vpw310A1V PI,
       oa1t.vpw301A1V PM,
       oa1t.vpw302A1V FA,
       oa1t.vpw318A1V MP
WHERE  FI.Laufzeit           =  0
  AND  FI.TimerTyp         like 'ARCH'
  AND  FI.Ausloese_Zeitpunkt >= '2006-10-16-16.39.13.817263'
  AND  FI.Ausloese_Zeitpunkt <= '9999-12-31-23.59.59.999999'
  AND  FI.FI_STATUS        like '%'
  AND  PI.Auftrags_Nummer  like '%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%'
  AND  PI.PI_Status          <> 'B'
  AND  PM.PM_Name like '%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%'
  AND  PI.PI_ID              =   FI.PI_ID
  AND  PI.PM_ID              =   PM.PM_ID
  AND  PM.EntryType          =  'R '
  AND  FI.MP_ID              =   MP.MP_ID
  AND  FI.FA_ID              =   FA.FA_ID
  AND  FA.EntryType          =  'R '
ORDER BY FI.Ausloese_Zeitpunkt ASC
;
select  (hour(current timestamp) * 60 + minute(current timestamp)) * 60
        + second(current timestamp),
        current timestamp, 'tst nach nur timertyp = ARCH'
    from sysibm.sysdummy1
;
SELECT FI.FI_ID,
       FI.FI_Status,
       PI.Auftrags_Nummer,
       FI.TimerTyp,
       FI.Ausloese_Zeitpunkt,
       MP.ED_Kurzname,
       FA.FD_Name,
       PM.PM_Name
FROM   oa1t.vpw311A1V FI,
       oa1t.vpw310A1V PI,
       oa1t.vpw301A1V PM,
       oa1t.vpw302A1V FA,
       oa1t.vpw318A1V MP
WHERE  FI.Laufzeit           =  0
  AND  FI.TimerTyp         like '%%%%'
  AND  FI.Ausloese_Zeitpunkt >= '2006-10-16-16.39.13.817263'
  AND  FI.Ausloese_Zeitpunkt <= '9999-12-31-23.59.59.999999'
  AND  FI.FI_STATUS        like '%'
  AND  PI.Auftrags_Nummer  like '%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%'
  AND  PI.PI_Status          <> 'B'
  AND  PM.PM_Name like 'WB Boerse Zuteilung bis Infra%%%%%%%%%%%%%%%%%%'
  AND  PI.PI_ID              =   FI.PI_ID
  AND  PI.PM_ID              =   PM.PM_ID
  AND  PM.EntryType          =  'R '
  AND  FI.MP_ID              =   MP.MP_ID
  AND  FI.FA_ID              =   FA.FA_ID
  AND  FA.EntryType          =  'R '
ORDER BY FI.Ausloese_Zeitpunkt ASC
;
select  (hour(current timestamp) * 60 + minute(current timestamp)) * 60
        + second(current timestamp),
        current timestamp, 'tst nach nur prozess modell'
    from sysibm.sysdummy1
;
SELECT FI.FI_ID,
       FI.FI_Status,
       PI.Auftrags_Nummer,
       FI.TimerTyp,
       FI.Ausloese_Zeitpunkt,
       MP.ED_Kurzname,
       FA.FD_Name,
       PM.PM_Name
FROM   oa1t.vpw311A1V FI,
       oa1t.vpw310A1V PI,
       oa1t.vpw301A1V PM,
       oa1t.vpw302A1V FA,
       oa1t.vpw318A1V MP
WHERE  FI.Laufzeit           =  0
  AND  FI.TimerTyp         like '%%%%'
  AND  FI.Ausloese_Zeitpunkt >= '2006-10-16-16.39.13.817263'
  AND  FI.Ausloese_Zeitpunkt <= '9999-12-31-23.59.59.999999'
  AND  FI.FI_STATUS        like '%'
  AND  PI.Auftrags_Nummer  like 'F%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%'
  AND  PI.PI_Status          <> 'B'
  AND  PM.PM_Name          like '%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%'
  AND  PI.PI_ID              =   FI.PI_ID
  AND  PI.PM_ID              =   PM.PM_ID
  AND  PM.EntryType          =  'R '
  AND  FI.MP_ID              =   MP.MP_ID
  AND  FI.FA_ID              =   FA.FA_ID
  AND  FA.EntryType          =  'R '
ORDER BY FI.Ausloese_Zeitpunkt ASC
;
select  (hour(current timestamp) * 60 + minute(current timestamp)) * 60
        + second(current timestamp),
        current timestamp, 'tst nach nur teil auftragsNr'
    from sysibm.sysdummy1
;
SELECT FI.FI_ID,
         FI.FI_Status,
         PI.Auftrags_Nummer,
         FI.TimerTyp,
         FI.Ausloese_Zeitpunkt,
         MP.ED_Kurzname,
         FA.FD_Name,
         PM.PM_Name
  FROM   oa1t.VPW311A1V FI,
         oa1t.VPW310A1V PI,
         oa1t.VPW301A1V PM,
         oa1t.VPW302A1V FA,
         oa1t.VPW318A1V MP
  WHERE  FI.Laufzeit           =  0
    AND  FI.TimerTyp         like 'ARCH'
    AND  FI.Ausloese_Zeitpunkt >= '2005-09-14-09.16.00.000000'
    AND  FI.Ausloese_Zeitpunkt <= '2007-12-31-23.59.00.000000'
    AND  FI.FI_STATUS        like '%'
    AND  PI.Auftrags_Nummer  like '%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%'
    AND  PI.PI_Status          <> 'B'
    AND  PM.PM_Name          like '%'
    AND  PI.PI_ID              =   FI.PI_ID
    AND  PI.PM_ID              =   PM.PM_ID
    AND  PM.EntryType          =  'R '
    AND  FI.MP_ID              =   MP.MP_ID
    AND  FI.FA_ID              =   FA.FA_ID
    AND  FA.EntryType          =  'R '
   ORDER BY FI.Ausloese_Zeitpunkt ASC
   FOR FETCH ONLY
   with ur
;
select  (hour(current timestamp) * 60 + minute(current timestamp)) * 60
        + second(current timestamp),
        current timestamp, 'tst nach altem query'
    from sysibm.sysdummy1
;