Drop Data

[tulsidaskhan]

Hi,

After every reload a date is captured in a variable. can i drop data for this particular date  by using drop statement.

Assumption: Something like  " Drop table Abc where date<= variable"

Thanks,

Piyush Jain

[Kushal_Chawda]

How you are capturing the Date in variable?

[Mark_Little]

Hi,

You would need to do a resident load.

So

Load

     *

Resident YourTable

Where Date > $(variable);

might need to think about the date formats,

Mark

[jonathandienst]

Like this:

If date <= variable Then

      Drop table Abc;

End If

Make sure that the date and the variables are valid numeric date values.