Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
How you are capturing the Date in variable?
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
Like this:
If date <= variable Then
Drop table Abc;
End If
Make sure that the date and the variables are valid numeric date values.