6 Replies Latest reply: Jan 23, 2018 1:37 PM by Jahanzeb Hashmi RSS

    How best way to make a incremental qvd?

    Eduardo DImperio

      Hi,

       

      I have a doubt about best way to make a incremental qvd:

       

      1-

      MSG_ALR:

      LOAD DISTINCT

          ID_MSG_REC,

          DT_REC,

          MODULE_ID as ID_MODULE,

          SubField(MSG, ',' ,5) AS OCORRENCIA

      resident CM_MSG_REC WHERE SubField(MSG, ',' ,5)='BEGIN';

       

       

      DROP TABLE CM_MSG_REC;

       

       

      MSG_ALR:

      LOAD

      *

      From

      [lib://Dados/MI/MSG/CM_MSG_REC_ALR.qvd] (qvd);

       

       

      STORE MSG_ALR INTO [lib://Dados/MI/MSG/CM_MSG_REC_ALR.qvd] (qvd);

       

      2-

      MSG_ALR:

      LOAD DISTINCT

          ID_MSG_REC,

          DT_REC,

          MODULE_ID as ID_MODULE,

          SubField(MSG, ',' ,5) AS OCORRENCIA

      resident CM_MSG_REC WHERE SubField(MSG, ',' ,5)='BEGIN';

       

       

      DROP TABLE CM_MSG_REC;

       

       

      CONCATENATE(MSG_ALR)

       

      LOAD

      *

      From

      [lib://Dados/MI/MSG/CM_MSG_REC_ALR.qvd] (qvd);

       

       

      STORE MSG_ALR INTO [lib://Dados/MI/MSG/CM_MSG_REC_ALR.qvd] (qvd);

       

       

      But if have a third option, I'll glad to hear about it.

       

      Thank you