Delete function in qvd

[#1]

Hi,

What command can I use to delete a week number in a particular year from a qvd?

something like below:

Table Name:

LOAD *

FROM

test.qvd(qvd)

????????????

Where Year = '2011' and Week = '48'

;

STORE Table Name into test.qvd;

Im not sure if there is a command e.g. Delete

Thanks,

Gregg

[jagan]

Hi,

Try the following script

TableName:

LOAD *

FROM

test.qvd(qvd)

Where Year<> 2011 and Week <> 48;

STORE TableName into test.qvd;

Hope this helps you.

Regards,

Jagan.

[#3]

Hi,

Do you know if this wont delete everything from 2011, only the week 48 from2011?

Thanks,

Gregg

[jagan · Accepted solution]

Hi,

It won't delete every thing in 2011, because we used and condition for week 48.  The records which has Year as 2011 and Week as 48 will be deleted.

Hope this helps you.

Regards,

jagan.