QVD Creation

[#1]

Hi All,

How to create QVD files, Different ways to create a QVD

SRS

[#2]

Hi,

I use semicolon there but not work.

SRS

[janardhan]

Save it first and do reload it will work

[#4]

Hi,

I save it and reload it but not work my scrpt is this

Table1:

load * from

D1;

store Table1 into Table1.qvd;

Table2:

load * from

D1;

store Table2 into Table2.qvd;

SRS

[janardhan]

try like this

Table1:

load * from

D1;

store Table1 into Table1.qvd;

drop table Table1;

Table2:

load * from

D1;

store Table2 into Table2.qvd;

drop table Table2;

[its_anandrjs · Accepted solution]

Hi,

Use some thing like this in the script

Table1:

load * from

D1;

store Table1 into Table1.qvd;

Table2:

NoConcatenate

load * from

D1;

store Table2 into Table2.qvd;

Regards,

Anand

[nilesh_gangurde]

Hi sanjay,

Attach a sample qvw file.

Regards,

Nilesh Gangurde

[Sokkorn]

Hi,

I try your script and working for me. Let see in the attached files.

Edit: Put all files in the same folder.

Regards,

Sokkorn

[#9]

Hi,

But it create synthetic keys.

SRS

[its_anandrjs]

Hi,

If you not need the loaded tables so delete it and use the QVD files.

Regards,

Anand

[rotero]

may i ask... is there an effect of you issue drop table after the store statement?

and also what is nonconcaatenate use for?