3 Replies Latest reply: Feb 16, 2016 8:30 PM by PAUL YEO RSS

    How to aviod running file reduction script ?

    PAUL YEO

      Hi All

       

       

      I want to reduce my QV data file size by create a sample QV Doc.

       

       

      SET vDevelopment = 1; // 1 min 55 sec  local        QVD_PY      10% of Sample data.

       

       

      above script will load all the sample raw data file. which can reduce the file size from 35 Mb to 14 Mb.

       

       

      I want to further to reduce the total file size from 14Mb to 9 Mb , by below script :-

       

       

      NEW:

      NOCONCATENATE

      LOAD *

      RESIDENT sales_table WHERE BRAND_='HMS';

       

      DROP TABLES sales_table;

       

       

      Now my question is how to make my program only run above script when run :-

       

       

      SET vDevelopment = 1; // 1 min 55 sec  local        QVD_PY      10% of Sample data.

       

       

      As i have other script:-

       

       

      set vDevelopment = 2;

       

       

      it will run full raw data file , and i want to avoid running :-

       

       

      NEW:

      NOCONCATENATE

      LOAD *

      RESIDENT sales_table WHERE BRAND_='HMS';

       

      DROP TABLES sales_table;

       

       

       

       

      Hope some one can advise me.

       

       

      Paul