Script Problem

[sat_tok52]

Hi Guru's,

As per my customer requirement i have to run qvd data in UAT Server without Where condition for user testing  and suppose if i moved that qvw into production server after  testing completion it should run same qvd  with where condition .How would i write the script.I tried like below.is It's not working ?Any help.

If vservername='UAT' then

Load

A,B

From Database

Endif

If vservername='Production' then

Load

A,B

From Database

Where Year=2015

Endif

Thanks,

Sateesh

[maxgro]

Replace autogenerate with your load from db

set vservername='UAT';

If vservername='UAT' then

  trace UAT;

  Load

  1 as A, 2 as B

  AutoGenerate 100;

Endif

If vservername='Production' then

  trace Production;

  Load

  1 as A, 2 as B

  AutoGenerate 20

  Where 1=1;

Endif