DSXchange

I'm using the same server job to load the one of historic load and the incremental load, just passing it different parameters. When I run the one off historic load i want to clear down the hashed files first. When I run the incremental load i don't want the hashed file cleared because I'm only appen...

Sorry to waist your time I think I have found the asnwer:

set up a before-job or before-stage subroutine, choose ExecTCL from the drop-down list, and execute the command:
CLEAR.FILE hashed_file_name

What is the best way to clear down hashed files.

I want a stage in a LoadAllFromScratch job/sequence which first clears down the hashed files that have been populated during all development and testing.

Do i need to write this in DS basic? If so what is the command?

Cheers, Nick.

Thanks, It looks like I need to do this in a controlling job.

I will have a go and no doubt be back with another question when it doesn't work!

Cheers, Nick.

I need to assign a date to a job parameter so it can be used to restrict the records returned from my source system. The date I need will be extracted from SAP BW prior to the job being run so the job knows the last successful load date. It can be extracted into either a hashed file or a flat file. ...