I have a table SALES_DATA in which a number of different source files are concatenated. I need to replace the contents of only file SAMPLE4.XLS, How would I go about doing this :
SALES_DATA:
CONCATENATE(SALES_DATA)
LOAD *
FROM SAMPLE1.XLS.......;
CONCATENATE(SALES_DATA)
LOAD *
FROM SAMPLE2.XLS.......;
CONCATENATE(SALES_DATA)
LOAD *
FROM SAMPLE3.XLS.......;
CONCATENATE(SALES_DATA)
LOAD *
FROM SAMPLE4.XLS.......;
STORE SALES_DATA INTO [...............................](qvd);