2 Replies Latest reply: Sep 21, 2015 3:40 AM by Amit Saini RSS

    Script Help ???

    Amit Saini

      Hi Folks ,

       

      Below is my QVD Gen script , triggered on hourly basis. Currently I'm facing some issue with the data , sometimes I'm missing some data from the Stichprobe table ,so to avoid this situation what I'm looking is to recreate this qvd over the weekends for the past whole week .

       

      STICHPROBE:

      LOAD

          '$(vPlant)' as Plant,

          *;

      SQL SELECT

      NSPCIDNR,

      NTOOLNR,

      NSTPNR,

      NPERS_IDNR

      FROM $(vPlantAutor).STICHPROBE

      WHERE DTTSERF > to_timestamp('$(vLAST_LOAD_TIME)', 'DD.MM.YYYY HH24:MI:SS');

       

      store STICHPROBE into $(vQVDCurrentYear)\$(vPlant)_STICHPROBE.qvd;

       

       

      Below is example:

       

      Today is Monday 21st Sep , so this qvd gen will work as it is triggered currently till Friday midnight  , but on Sat or Sun what I'm looking for is to call the data from the complete week starting from 21st till 25th sep .

       

      Please help me on this task , how can I do this by using above script.

       

      Thanks,

      AS