0 Replies Latest reply: Sep 26, 2012 10:07 AM by Erik Furlanis RSS

    [incremental load] Cannot manage to 1. load QVX 2. properly append new data to existing QVX

      Hi!

       

      I'm adventuring in the incremental load subject and I'm facing a couple of issues.

      I created a qvx file where I stored my orders data and I wanted to do an incremental load with orders that were entered today.

       

      This is how the script looks like

       

      LOAD *,
      order as KEY;
      SQL SELECT * FROM DB.TABLE
      WHERE LODTE >= '$(vToday)';
      Concatenate LOAD *
      FROM \\server\drive\folder\2012.qvx (qvd)
      WHERE NOT Exists(KEY);
      STORE DB.TABLE INTO \\server\drive\folder\2012_increment.qvx;
      

       

      This is the only script version that I managed to make it works.

      Please note that I had to enter the (qvd) parameter when loading the original QVX.

      With this script the incremental load works as expected and the resulting data also matches expectations.

       

      If I write instead

       

      Concatenate LOAD *
      FROM \\server\drive\folder\2012.qvx
      WHERE NOT Exists(KEY);
      STORE DB.TABLE INTO \\server\drive\folder\2012_increment.qvx;
      

       

      so excluding the (qvd) parameter, it does not work.

       

      So it seems like that qvx is not handled when making incremental loads?

      Without the (qvd) parameter, it does not load; when I attempt to open the freshly created 2012_increment.qvx, QV recognises it as QVD in the wizard.

       

      Second issue:

       

      I cannot manage to integrate the current qvx with new information. I.e., if I write

       

      Concatenate LOAD *
      FROM \\server\drive\folder\2012.qvx (qvd)
      WHERE NOT Exists(KEY);
      STORE DB.TABLE INTO \\server\drive\folder\2012.qvx (qvd);
      

       

      in order to fetch data from my qvx and integrate it with the freshly retrieved data from the DB, it does not work. It fails both if I use or not the (qvd) parameters.

       

      Indeed if I read the reference manual, it writes:

       

      QV_Table:
      SQL SELECT PrimaryKey, X, Y FROM DB_TABLE
      WHERE ModificationTime >= #$(LastExecTime)#;
      Concatenate LOAD PrimaryKey, X, Y FROM File.QVD
      WHERE NOT Exists(PrimaryKey);
      STORE QV_Table INTO File.QVD;
      

       

      I'm using QV 10 if it is of any help.

      Thanks!