Unable to mail a spooled file

pras · Post by **pras** » Fri Apr 28, 2006 1:52 am

we are using a batch job to spool a excel file and to send the same thru mail

but we are not getting the mail

the error we are getting is

collect: Cannot write ./dfk3S7Cfi22696 (fflush||ferror, uid=0)

but the file is created in the specified path

thanks
Prasanna

ArndW · Post by **ArndW** » Fri Apr 28, 2006 2:05 am

Hello Prasanna, could you elaborate a bit on what you are doing? To "spool" a file means to print it so your question confuses me a bit. Is this a DataStage batch/Sequence? Which program is generating the error you posted?

pras · Post by **pras** » Fri Apr 28, 2006 3:56 am

ArndW wrote:Hello Prasanna, could you elaborate a bit on what you are doing? To "spool" a file means to print it so your question confuses me a bit. Is this a DataStage batch/Sequence? Which program is generating the error you posted?

Hi Arn

Yeah it is a Datastage/batch.

we are using a batch job, which will do validation between two tables
and will send the result in a excel as a mail attachment

when we run this job it is running fine and creating the Excel in the specified path, but it is not sending this excel file to us

it is in this place the error comes into the picture.

thanks
Prasanna

ArndW · Post by **ArndW** » Fri Apr 28, 2006 4:09 am

I assume you mean a .csv comma-separated Excel file; since as far as I know DS cannot create excel files.

What call are you using to send the finished file, is it the DSSendMail function call from the sequence and if so, what are the paramters?