Skip to Content
0
Former Member
May 15, 2008 at 02:01 PM

downloading query results in background

198 Views

Hi -- I have a simple query that I would like to run on a daily basis to download information for a 3rd party system. Two questions:]

(1) I would like the output file to automatically overwrite the previous day's file. When I run the query in dialog mode, I am notified that the file already exists and provided with the option to overwrite it. But when I run the query in background mode, it doesn't overwrite the file. Does anyone know how I can force it to overwrite? I should note that I am using the 'File store' option under Output format.

(2) Every line in my output file has an extraneous '0' at the end of the line. In fact, it's like a whole extra output column, always populated with '0'. Does anyone know how I can get rid of this? It's happening if I specify the file as a .xls or as a .txt file.

Thanks for any guidance!!