3 Replies Latest reply: Oct 25, 2014 10:08 AM by Srikanth P RSS

    Applymap with time range

    Sifat Rahman

      Hi,

       

      I have data from an Oracle database, where there is a field called MSG_DATE_TIME which is of data type = "timestamp (6) with local time zone".

       

      When the main table updates with a new row, the mapping table updates immediately after, with a few milliseconds delay, like 5 milliseconds. I want to map the FIXING_STATE, so the mapping load would be like this:

       

      mapstate:

      MAPPING LOAD

           MSG_DATE_TIME & ' ' & DESCRIPTION,

           FIXING_STATE

      Resident mappingtable;

       

      The problem is that the MSG_DATE_TIME in the main table and mapping table lag by 5 milliseconds. How can the mapping be done such that the applymap statement can accommodate the 5 millisecond lag time?

       

      The logic would be something like this:

      applymap('mapstate',MSG_DATE_TIME within 5 milliseconds & ' ' & DESCRIPTION)

       

      Thanks.