How to aviod running file reduction script ?

[paulyeo11]

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

[paulyeo11]

Below is my sample QV Doc

[jagan · Accepted solution]

Hi,

Try like this using IF

IF vDevelopment = 1 THEN

NEW:

NOCONCATENATE

LOAD *

RESIDENT sales_table WHERE BRAND_='HMS';

DROP TABLES sales_table;

END IF;

Regards,

Jagan.

[paulyeo11]

Hi Jagan

Thank you vey much , it work fine.

Paul