Lotus Notes

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
ewartpm
Participant
Posts: 97
Joined: Wed Jun 25, 2003 2:15 am
Location: South Africa
Contact:

Lotus Notes

Post by ewartpm »

Can DataStage send an email message to Lotus Notes[?] I'm busy with a proof of concept and this is a critical issue. The client want's to be notified if any jobs aborted or generated warnings etc via emai.

Thanks
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Well, you can certainly send emails *to* Lotus Notes. [:)] DataStage doesn't care what email tool the recepient is using.

If you meant 'from', I don't see why not. As far as I remember, Notes supports SMTP and so should be usable as long as it is accessable from whereever DataStage is installed.

Check out the DSSendMail function plus the 'Email Notification' stage in Sequence jobs. Read the writeup in the manuals. It explains how to configure the 'template' it uses to communicate with whatever email server you are using, NT or Unix.

-craig
ewartpm
Participant
Posts: 97
Joined: Wed Jun 25, 2003 2:15 am
Location: South Africa
Contact:

Post by ewartpm »

[:D]Thanks Craig[:D]
quote:Originally posted by chulett
[br]Well, you can certainly send emails *to* Lotus Notes. [:)] DataStage doesn't care what email tool the recepient is using.

If you meant 'from', I don't see why not. As far as I remember, Notes supports SMTP and so should be usable as long as it is accessable from whereever DataStage is installed.

Check out the DSSendMail function plus the 'Email Notification' stage in Sequence jobs. Read the writeup in the manuals. It explains how to configure the 'template' it uses to communicate with whatever email server you are using, NT or Unix.

-craig
gpbarsky
Participant
Posts: 160
Joined: Tue May 06, 2003 8:20 pm
Location: Argentina

Post by gpbarsky »

Dear friend:

Here you have a small routine, which receives several parameters and sends the mail.

Parameters are:
pmSendTo
pmSubject
pmImportancia
pmL1
pmL2
....
pmL20

You have to contact your administrator in order to see the xServer and xFrom variables how to fill them in.

pmL1 to pmL20 are to possible lines you can send in the mail.

Good luck.
---------------------------------------------------------------------
*
* Envio de notas
*
Ans = "";
Deffun DSSendMail(A);
*
xFrom = "From:notificacion-etl@osde.com.ar";
xTo = "To:":pmSendTo;
xSubject = "Subject:":pmSubject;
xServer = "Server:osde-central-2.osde";
xBody = "Body: IMPORTANCIA-":pmImportancia;
xBody = xBody:" n n":pmL1;
xBody = xBody:" n":pmL2;
xBody = xBody:" n":pmL3;
xBody = xBody:" n":pmL4;
xBody = xBody:" n":pmL5;
xBody = xBody:" n":pmL6;
xBody = xBody:" n":pmL7;
xBody = xBody:" n":pmL8;
xBody = xBody:" n":pmL9;
xBody = xBody:" n":pmL10;
xBody = xBody:" n":pmL11;
xBody = xBody:" n":pmL12;
xBody = xBody:" n":pmL13;
xBody = xBody:" n":pmL14;
xBody = xBody:" n":pmL15;
xBody = xBody:" n":pmL16;
xBody = xBody:" n":pmL17;
xBody = xBody:" n":pmL18;
xBody = xBody:" n":pmL19;
xBody = xBody:" n":pmL20;
xBody = xBody : " n n n*** DataStage - Cobranzas ***";
*
rc = DSSendMail(xFrom:"n":xTo:"n":xSubject:"n":xServer:"n":xBody:"n");
*
IF rc "0"
THEN
CALL DSLogFatal("Error en el DSSendMail.","MSG");
Ans = "ERROR";
END
ELSE
CALL DSLogInfo("** Se ha enviado un mail a ":pmSendTo:" por el asunto ":pmSubject:".","MSG");
Ans = "OK";
END
---------------------------------------------------------------------


Guillermo P. Barsky
Buenos Aires - Argentina
Post Reply