DSSendMail - Attachement - DataStage Server 7.0

[caltog]

Hello

I try to look for an answer in the forum but I only found for 7.5.
Is there any possibility to attach a file with DSSendmail or with Notification Activity ?

Thanks

[abhi989]

two ways you can do it.

1) through unix
add an execute command activity stage in a sequence.

type as follow

Under command : /bin/ls
Under Parameters : directory_where_the_file_is; mail -s 'subject email_address_you_want_to_mail_to<full_path_to_the_location_to_the_file

2)

Add Notification Activity stage -- type necessary parameters

[ray.wurlod]

Support for attachments in the Notification Activity was introduced in version 7.5. It is not available in versions earlier than this.

I can only assume (not having version 7.0 to check) that the same is true for the DSSendMail() function. However, since DSSendMail() ultimately calls the sendmail() function - the SMTP client, you could create your own mailer and invoke that from your job sequence via Execute Command.

[chulett]

You can also use uuencode for the attachment file and pipe the output to a mail function like mailx for example.

D'oh! If you were on UNIX, that is.

For Windows, I'd stick with blat.

[kduke]

In EtlStats there is a routine to call to send attachments using blat.exe for Windows and another using Craig's method calling a shell script named Email.ksh. Both are included in the zip file. I think both have been posted on this site.

[caltog]

Thanks a lot

I'll investigate yours answers.

[saikir]

Hi,

As stated earlier by Ray, the option to attach files is introduced in 7.5. You can use Blat for sending mails with attachments. We have been using blat succesfully in our project for some time now

Sai

[caltog]

It' s work with :

uuencode "FilenameWithPath" "FileNameInMail" | mailx -s "MailSubject" "Recipient"

But juste for one attached file.

Thanks