DSXchange

TWlzdGVycywNCmlzIHRoZXJlIGEgd2F5LCBpbiBkYXRhc3RhZ2UsIHRvIHNlbmQgYW4gZW1haWwg
d2hlbiBzb21lIGNvbmRpdGlvbiBvY2N1cnM/DQpUa3MsDQpBbGV4DQo=

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

Alex:

This is the ROUTINE that I use to send mails, using DSSendMail function.
You have to contact to your notes administrator to determine the value to
set for: xFrom and xServer.

Parameteres pmL1..pmL20 are each line that I want to include in the note.

This routine receives the following parameters:
pmSendTo
pmSubject
pmImportancia
pmL1
pmL2
pmL3
pmL4
pmL5
pmL6
pmL7
pmL8
pmL9
pmL10
pmL11
pmL12
pmL13
pmL14
pmL15
pmL16
pmL17
pmL18
pmL19
pmL20

*
* 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


Guillermo P. Barsky - gbarsky@osde.com.ar
Gerencia de Sistemas - Desarrollo

OSDE Binario - Filial Metropolitana
Alem 1067, Piso 16
TE (5411)4510-4330, Fax (5411)4510-5480
http://www.osde.com.ar



"Alex Martins"
Para:
Enviado por: cc:
datastage-users-bounces Asunto: trigger email
@oliver.com


17/02/2004 01:48 p.m.
Por favor, responda a
DataStage Users
Discussion List






Misters,
is there a way, in datastage, to send an email when some condition occurs?
Tks,
Alex
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users



_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

R3VpbGxlcm1vLA0KSSBub3RpY2UgdGhlIHdheSB5b3UgZGVmaW5lIGEgZnVuY3Rpb246DQogDQpE
ZWZmdW4gRFNTZW5kTWFpbChBKTsNCg0KSSBjYW7CtHQgcnVuIGEgam9iIGNvbnRyb2wgaGVyZSB0
aGF0IGhhdmUgdGhpczoNCiANCkRlZmZ1biBVSGFzaExvb2t1cChBMSwgQTIsIEEzKSBDYWxsaW5n
ICJEU1UuVXRpbGl0eUhhc2hMb29rdXAiDQpQX0RBVEFfSU5JQ0lBTCA9IFVIYXNoTG9va3VwKCJI
U0hfTUFYX0NPUkRXMDgyIiwxLDEpDQogDQpJdCBnaXZlcyBubyBtZXNzYWdlLCBidXQgYXR0cmli
dXRlcyBubyB2YWx1ZSB0byBQX0RBVEFfSU5JQ0lBTCBlaXRoZXIuDQpDb3VsZCB5b3UgaGVscCBt
ZSB3aXRoIHRoaXMgdG9vPw0KIA0KTXVjaGFzIGdyYWNpYXMsDQpBbGV4DQogDQotLS0tLU1lbnNh
Z2VtIG9yaWdpbmFsLS0tLS0gDQpEZTogZ2JhcnNreUBvc2RlLmNvbS5hciBbbWFpbHRvOmdiYXJz
a3lAb3NkZS5jb20uYXJdIA0KRW52aWFkYTogdGVyIDE3LzAyLzIwMDQgMTQ6MTAgDQpQYXJhOiBk
YXRhc3RhZ2UtdXNlcnNAb2xpdmVyLmNvbSANCkNjOiANCkFzc3VudG86IFJlOiB0cmlnZ2VyIGVt
YWlsDQoNCg0KDQoNCg0KDQoNCglBbGV4Og0KCQ0KCVRoaXMgaXMgdGhlIFJPVVRJTkUgdGhhdCBJ
IHVzZSB0byBzZW5kIG1haWxzLCB1c2luZyBEU1NlbmRNYWlsIGZ1bmN0aW9uLg0KCVlvdSBoYXZl
IHRvIGNvbnRhY3QgdG8geW91ciBub3RlcyBhZG1pbmlzdHJhdG9yIHRvIGRldGVybWluZSB0aGUg
dmFsdWUgdG8NCglzZXQgZm9yOiB4RnJvbSBhbmQgeFNlcnZlci4NCgkNCglQYXJhbWV0ZXJlcyBw
bUwxLi5wbUwyMCBhcmUgZWFjaCBsaW5lIHRoYXQgSSB3YW50IHRvIGluY2x1ZGUgaW4gdGhlIG5v
dGUuDQoJDQoJVGhpcyByb3V0aW5lIHJlY2VpdmVzIHRoZSBmb2xsb3dpbmcgcGFyYW1ldGVyczoN
CglwbVNlbmRUbw0KCXBtU3ViamVjdA0KCXBtSW1wb3J0YW5jaWENCglwbUwxDQoJcG1MMg0KCXBt
TDMNCglwbUw0DQoJcG1MNQ0KCXBtTDYNCglwbUw3DQoJcG1MOA0KCXBtTDkNCglwbUwxMA0KCXBt
TDExDQoJcG1MMTINCglwbUwxMw0KCXBtTDE0DQoJcG1MMTUNCglwbUwxNg0KCXBtTDE3DQoJcG1M
MTgNCglwbUwxOQ0KCXBtTDIwDQoJDQoJKg0KCSogRW52aW8gZGUgbm90YXMNCgkqDQoJQW5zID0g
IiI7DQoJRGVmZnVuIERTU2VuZE1haWwoQSk7DQoJKg0KCXhGcm9tICAgID0gIkZyb206bm90aWZp
Y2FjaW9uLWV0bEBvc2RlLmNvbS5hciI7DQoJeFRvICAgICAgPSAiVG86IjpwbVNlbmRUbzsNCgl4
U3ViamVjdCA9ICJTdWJqZWN0OiI6cG1TdWJqZWN0Ow0KCXhTZXJ2ZXIgID0gIlNlcnZlcjpvc2Rl
LWNlbnRyYWwtMi5vc2RlIjsNCgl4Qm9keSAgICA9ICJCb2R5OiBJTVBPUlRBTkNJQS0iOnBtSW1w
b3J0YW5jaWE7DQoJeEJvZHkgICAgPSB4Qm9keToiIFxuIFxuIjpwbUwxOw0KCXhCb2R5ICAgID0g
eEJvZHk6IiBcbiI6cG1MMjsNCgl4Qm9keSAgICA9IHhCb2R5OiIgXG4iOnBtTDM7DQoJeEJvZHkg
ICAgPSB4Qm9keToiIFxuIjpwbUw0Ow0KCXhCb2R5ICAgID0geEJvZHk6IiBcbiI6cG1MNTsNCgl4
Qm9keSAgICA9IHhCb2R5OiIgXG4iOnBtTDY7DQoJeEJvZHkgICAgPSB4Qm9keToiIFxuIjpwbUw3
Ow0KCXhCb2R5ICAgID0geEJvZHk6IiBcbiI6cG1MODsNCgl4Qm9keSAgICA9IHhCb2R5OiIgXG4i
OnBtTDk7DQoJeEJvZHkgICAgPSB4Qm9keToiIFxuIjpwbUwxMDsNCgl4Qm9keSAgICA9IHhCb2R5
OiIgXG4iOnBtTDExOw0KCXhCb2R5ICAgID0geEJvZHk6IiBcbiI6cG1MMTI7DQoJeEJvZHkgICAg
PSB4Qm9keToiIFxuIjpwbUwxMzsNCgl4Qm9keSAgICA9IHhCb2R5OiIgXG4iOnBtTDE0Ow0KCXhC
b2R5ICAgID0geEJvZHk6IiBcbiI6cG1MMTU7DQoJeEJvZHkgICAgPSB4Qm9keToiIFxuIjpwbUwx
NjsNCgl4Qm9keSAgICA9IHhCb2R5OiIgXG4iOnBtTDE3Ow0KCXhCb2R5ICAgID0geEJvZHk6IiBc
biI6cG1MMTg7DQoJeEJvZHkgICAgPSB4Qm9keToiIFxuIjpwbUwxOTsNCgl4Qm9keSAgICA9IHhC
b2R5OiIgXG4iOnBtTDIwOw0KCXhCb2R5ICAgID0geEJvZHkgOiAiIFxuIFxuIFxuKioqIERhdGFT
dGFnZSAtIENvYnJhbnphcyAqKioiOw0KCSoNCglyYyA9IERTU2VuZE1haWwoeEZyb206IlxuIjp4
VG86IlxuIjp4U3ViamVjdDoiXG4iOnhTZXJ2ZXI6IlxuIjp4Qm9keToiXG4iKTsNCgkqDQoJSUYg
cmMgPD4gIjAiDQoJVEhFTg0KCSAgIENBTEwgRFNMb2dGYXRhbCgiRXJyb3IgZW4gZWwgRFNTZW5k
TWFpbC4iLCJNU0ciKTsNCgkgICBBbnMgPSAiRVJST1IiOw0KCUVORA0KCQ0KCQ0KCUd1aWxsZXJt
byBQLiBCYXJza3kgLSBnYmFyc2t5QG9zZGUuY29tLmFyDQoJR2VyZW5jaWEgZGUgU2lzdGVtYXMg
LSBEZXNhcnJvbGxvDQoJDQoJT1NERSBCaW5hcmlvIC0gRmlsaWFsIE1ldHJvcG9saXRhbmENCglB
bGVtIDEwNjcsIFBpc28gMTYNCglURSAoNTQxMSk0NTEwLTQzMzAsIEZheCAoNTQxMSk0NTEwLTU0
ODANCglodHRwOi8vd3d3Lm9zZGUuY29tLmFyDQoJDQoJDQoJICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgDQoJICAgICAgICAgICAgICAgICAgICAgICJBbGV4IE1hcnRpbnMiICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQoJICAgICAgICAgICAgICAgICAgICAgIDxB
bGV4QHByb2l0LmNvbS5icj4gICAgICAgICAgUGFyYTogICAgIDxkYXRhc3RhZ2UtdXNlcnNAb2xp
dmVyLmNvbT4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
DQoJICAgICAgICAgICAgICAgICAgICAgIEVudmlhZG8gcG9yOiAgICAgICAgICAgICAgICAgY2M6
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgDQoJICAgICAgICAgICAgICAgICAgICAgIGRhdGFz
dGFnZS11c2Vycy1ib3VuY2VzICAgICAgQXN1bnRvOiAgIHRyaWdnZXIgZW1haWwgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQoJ
ICAgICAgICAgICAgICAgICAgICAgIEBvbGl2ZXIuY29tICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgDQoJICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQoJICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgDQoJICAgICAgICAgICAgICAgICAgICAgIDE3LzAyLzIwMDQg
MDE6NDggcC5tLiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQoJICAgICAg
ICAgICAgICAgICAgICAgIFBvciBmYXZvciwgcmVzcG9uZGEgYSAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgDQoJICAgICAgICAgICAgICAgICAgICAgIERhdGFTdGFnZSBVc2Vy
cyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQoJICAgICAgICAg
ICAgICAgICAgICAgIERpc2N1c3Npb24gTGlzdCAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgDQoJICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQoJICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgDQoJDQoJDQoJDQoJDQoJTWlzdGVycywNCglpcyB0aGVyZSBhIHdheSwgaW4g
ZGF0YXN0YWdlLCB0byBzZW5kIGFuIGVtYWlsIHdoZW4gc29tZSBjb25kaXRpb24gb2NjdXJzPw0K
CVRrcywNCglBbGV4DQoJX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX18NCglkYXRhc3RhZ2UtdXNlcnMgbWFpbGluZyBsaXN0DQoJZGF0YXN0YWdlLXVzZXJzQG9s
aXZlci5jb20NCglodHRwOi8vd3d3Lm9saXZlci5jb20vbWFpbG1hbi9saXN0aW5mby9kYXRhc3Rh
Z2UtdXNlcnMNCgkNCgkNCgkNCglfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fXw0KCWRhdGFzdGFnZS11c2VycyBtYWlsaW5nIGxpc3QNCglkYXRhc3RhZ2UtdXNl
cnNAb2xpdmVyLmNvbQ0KCWh0dHA6Ly93d3cub2xpdmVyLmNvbS9tYWlsbWFuL2xpc3RpbmZvL2Rh
dGFzdGFnZS11c2Vycw0KCQ0KDQo=

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

Create a job sequence. Use a Notification Activity to send an email. Use the trigger on a preceding activity (for example the exit status of a Job Activity) to cause the Notification Activity to be invoked. Compile the job sequence then examine the code that is generated (Job properties, Job Control tab).
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users