DSXchange

Hi everybody.

I would like to have some tips about a case I have in my project.

I need to read a database daily, several times per day, and during the day I need to 'append' a file with these data and, when the day changes, the file must be overwritten and then start to 'append' it again.

PS. I can't create different files - one per day. The file must be the same: with the same name. We just overwrite it according to the date changing.

How can I make this control?

Thanks my friends.

Best regards,

Sounds like you need a "pre-process" to delete the file when the day changes, then the job can simply overwrite each time.

Hi Joyce.

What is behind the requirement that the file have the same name every day? My assumption for the rest of this post is that it is used by a subsequent job or process.

I have a similar situation in the other direction. I overwrite the same initial file every day, then have a process that makes a final edit to it, but the edited file has a unique name every day (current date in the file name).

I don't know if this will help, but one way to approach this:

Append to a uniquely named file each day. The current date is a handy way to do that. At the end of the day, copy it to the "must be the same name" file for further processing, and delete the current-date file when that is done.

Edit: Or what Craig suggested.