DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Wed Feb 18, 2004 6:07 am Reply with quote    Back to top    

R3VpbGxsZXJtbywNCg0KCWFuZCBmcm9tIHdoZXJlIGRvIHlvdSBjYWxsIHlvdXIgcm91dGluZT8N
CglUa3MsDQoJQWxleA0KDQoJCS0tLS0tTWVuc2FnZW0gb3JpZ2luYWwtLS0tLSANCgkJRGU6IGdi
YXJza3lAb3NkZS5jb20uYXIgW21haWx0bzpnYmFyc2t5QG9zZGUuY29tLmFyXSANCgkJRW52aWFk
YTogdGVyIDE3LzAyLzIwMDQgMTU6MzggDQoJCVBhcmE6IERhdGFTdGFnZSBVc2VycyBEaXNjdXNz
aW9uIExpc3QgDQoJCUNjOiANCgkJQXNzdW50bzogUmU6IFJFUzogdHJpZ2dlciBlbWFpbA0KCQkN
CgkJDQoNCg0KDQoNCg0KCQlBbGV4Og0KCQkNCgkJUmVhbGx5IEkgZG9uJ3Qga25vdyB3aGF0IHRv
IHRlbGwgeW91LiBSZW1lbWJlciB0aGF0IHRoZSBjb2RlIEkgZ2F2ZSB5b3UgaXMNCgkJd2l0aGlu
IGEgcm91dGluZS4gSSBkb24ndCBrbm93IGlmIHRoaXMgaXMgaW1wb3J0YW50LCBidXQuLi4uDQoJ
CQ0KCQkNCgkJR3VpbGxlcm1vIFAuIEJhcnNreSAtIGdiYXJza3lAb3NkZS5jb20uYXINCgkJR2Vy
ZW5jaWEgZGUgU2lzdGVtYXMgLSBEZXNhcnJvbGxvDQoJCQ0KCQlPU0RFIEJpbmFyaW8gLSBGaWxp
YWwgTWV0cm9wb2xpdGFuYQ0KCQlBbGVtIDEwNjcsIFBpc28gMTYNCgkJVEUgKDU0MTEpNDUxMC00
MzMwLCBGYXggKDU0MTEpNDUxMC01NDgwDQoJCWh0dHA6Ly93d3cub3NkZS5jb20uYXINCgkJDQoJ
CQ0KCQkgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCgkJICAgICAgICAgICAgICAgICAgICAgICJB
bGV4IE1hcnRpbnMiICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
DQoJCSAgICAgICAgICAgICAgICAgICAgICA8QWxleEBwcm9pdC5jb20uYnI+ICAgICAgICAgIFBh
cmE6ICAgICAiRGF0YVN0YWdlIFVzZXJzIERpc2N1c3Npb24gTGlzdCIgPGRhdGFzdGFnZS11c2Vy
c0BvbGl2ZXIuY29tPiAgICAgICAgICAgICAgIA0KCQkgICAgICAgICAgICAgICAgICAgICAgRW52
aWFkbyBwb3I6ICAgICAgICAgICAgICAgICBjYzogICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAN
CgkJICAgICAgICAgICAgICAgICAgICAgIGRhdGFzdGFnZS11c2Vycy1ib3VuY2VzICAgICAgQXN1
bnRvOiAgIFJFUzogdHJpZ2dlciBlbWFpbCAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgDQoJCSAgICAgICAgICAgICAgICAgICAgICBAb2xp
dmVyLmNvbSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0K
CQkgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICANCgkJICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQoJ
CSAgICAgICAgICAgICAgICAgICAgICAxNy8wMi8yMDA0IDAyOjMzIHAubS4gICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgIA0KCQkgICAgICAgICAgICAgICAgICAgICAgUG9yIGZh
dm9yLCByZXNwb25kYSBhICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCgkJ
ICAgICAgICAgICAgICAgICAgICAgIERhdGFTdGFnZSBVc2VycyAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgDQoJCSAgICAgICAgICAgICAgICAgICAgICBEaXNjdXNz
aW9uIExpc3QgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KCQkg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICANCgkJICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQoJCQ0K
CQkNCgkJDQoJCQ0KCQlHdWlsbGVybW8sDQoJCUkgbm90aWNlIHRoZSB3YXkgeW91IGRlZmluZSBh
IGZ1bmN0aW9uOg0KCQkNCgkJRGVmZnVuIERTU2VuZE1haWwoQSk7DQoJCQ0KCQlJIGNhbsK0dCBy
dW4gYSBqb2IgY29udHJvbCBoZXJlIHRoYXQgaGF2ZSB0aGlzOg0KCQkNCgkJRGVmZnVuIFVIYXNo
TG9va3VwKEExLCBBMiwgQTMpIENhbGxpbmcgIkRTVS5VdGlsaXR5SGFzaExvb2t1cCINCgkJUF9E
QVRBX0lOSUNJQUwgPSBVSGFzaExvb2t1cCgiSFNIX01BWF9DT1JEVzA4MiIsMSwxKQ0KCQkNCgkJ
SXQgZ2l2ZXMgbm8gbWVzc2FnZSwgYnV0IGF0dHJpYnV0ZXMgbm8gdmFsdWUgdG8gUF9EQVRBX0lO
SUNJQUwgZWl0aGVyLg0KCQlDb3VsZCB5b3UgaGVscCBtZSB3aXRoIHRoaXMgdG9vPw0KCQkNCgkJ
TXVjaGFzIGdyYWNpYXMsDQoJCUFsZXgNCgkJDQoJCS0tLS0tTWVuc2FnZW0gb3JpZ2luYWwtLS0t
LQ0KCQlEZTogZ2JhcnNreUBvc2RlLmNvbS5hciBbbWFpbHRvOmdiYXJza3lAb3NkZS5jb20uYXJd
DQoJCUVudmlhZGE6IHRlciAxNy8wMi8yMDA0IDE0OjEwDQoJCVBhcmE6IGRhdGFzdGFnZS11c2Vy
c0BvbGl2ZXIuY29tDQoJCUNjOg0KCQlBc3N1bnRvOiBSZTogdHJpZ2dlciBlbWFpbA0KCQkNCgkJ
DQoJCQ0KCQkNCgkJDQoJCQ0KCQkNCgkJICAgICAgICAgICAgIEFsZXg6DQoJCQ0KCQkgICAgICAg
ICAgICAgVGhpcyBpcyB0aGUgUk9VVElORSB0aGF0IEkgdXNlIHRvIHNlbmQgbWFpbHMsIHVzaW5n
IERTU2VuZE1haWwNCgkJZnVuY3Rpb24uDQoJCSAgICAgICAgICAgICBZb3UgaGF2ZSB0byBjb250
YWN0IHRvIHlvdXIgbm90ZXMgYWRtaW5pc3RyYXRvciB0byBkZXRlcm1pbmUNCgkJdGhlIHZhbHVl
IHRvDQoJCSAgICAgICAgICAgICBzZXQgZm9yOiB4RnJvbSBhbmQgeFNlcnZlci4NCgkJDQoJCSAg
ICAgICAgICAgICBQYXJhbWV0ZXJlcyBwbUwxLi5wbUwyMCBhcmUgZWFjaCBsaW5lIHRoYXQgSSB3
YW50IHRvIGluY2x1ZGUNCgkJaW4gdGhlIG5vdGUuDQoJCQ0KCQkgICAgICAgICAgICAgVGhpcyBy
b3V0aW5lIHJlY2VpdmVzIHRoZSBmb2xsb3dpbmcgcGFyYW1ldGVyczoNCgkJICAgICAgICAgICAg
IHBtU2VuZFRvDQoJCSAgICAgICAgICAgICBwbVN1YmplY3QNCgkJICAgICAgICAgICAgIHBtSW1w
b3J0YW5jaWENCgkJICAgICAgICAgICAgIHBtTDENCgkJICAgICAgICAgICAgIHBtTDINCgkJICAg
ICAgICAgICAgIHBtTDMNCgkJICAgICAgICAgICAgIHBtTDQNCgkJICAgICAgICAgICAgIHBtTDUN
CgkJICAgICAgICAgICAgIHBtTDYNCgkJICAgICAgICAgICAgIHBtTDcNCgkJICAgICAgICAgICAg
IHBtTDgNCgkJICAgICAgICAgICAgIHBtTDkNCgkJICAgICAgICAgICAgIHBtTDEwDQoJCSAgICAg
ICAgICAgICBwbUwxMQ0KCQkgICAgICAgICAgICAgcG1MMTINCgkJICAgICAgICAgICAgIHBtTDEz
DQoJCSAgICAgICAgICAgICBwbUwxNA0KCQkgICAgICAgICAgICAgcG1MMTUNCgkJICAgICAgICAg
ICAgIHBtTDE2DQoJCSAgICAgICAgICAgICBwbUwxNw0KCQkgICAgICAgICAgICAgcG1MMTgNCgkJ
ICAgICAgICAgICAgIHBtTDE5DQoJCSAgICAgICAgICAgICBwbUwyMA0KCQkNCgkJICAgICAgICAg
ICAgICoNCgkJICAgICAgICAgICAgICogRW52aW8gZGUgbm90YXMNCgkJICAgICAgICAgICAgICoN
CgkJICAgICAgICAgICAgIEFucyA9ICIiOw0KCQkgICAgICAgICAgICAgRGVmZnVuIERTU2VuZE1h
aWwoQSk7DQoJCSAgICAgICAgICAgICAqDQoJCSAgICAgICAgICAgICB4RnJvbSAgICA9ICJGcm9t
Om5vdGlmaWNhY2lvbi1ldGxAb3NkZS5jb20uYXIiOw0KCQkgICAgICAgICAgICAgeFRvICAgICAg
PSAiVG86IjpwbVNlbmRUbzsNCgkJICAgICAgICAgICAgIHhTdWJqZWN0ID0gIlN1YmplY3Q6Ijpw
bVN1YmplY3Q7DQoJCSAgICAgICAgICAgICB4U2VydmVyICA9ICJTZXJ2ZXI6b3NkZS1jZW50cmFs
LTIub3NkZSI7DQoJCSAgICAgICAgICAgICB4Qm9keSAgICA9ICJCb2R5OiBJTVBPUlRBTkNJQS0i
OnBtSW1wb3J0YW5jaWE7DQoJCSAgICAgICAgICAgICB4Qm9keSAgICA9IHhCb2R5OiIgXG4gXG4i
OnBtTDE7DQoJCSAgICAgICAgICAgICB4Qm9keSAgICA9IHhCb2R5OiIgXG4iOnBtTDI7DQoJCSAg
ICAgICAgICAgICB4Qm9keSAgICA9IHhCb2R5OiIgXG4iOnBtTDM7DQoJCSAgICAgICAgICAgICB4
Qm9keSAgICA9IHhCb2R5OiIgXG4iOnBtTDQ7DQoJCSAgICAgICAgICAgICB4Qm9keSAgICA9IHhC
b2R5OiIgXG4iOnBtTDU7DQoJCSAgICAgICAgICAgICB4Qm9keSAgICA9IHhCb2R5OiIgXG4iOnBt
TDY7DQoJCSAgICAgICAgICAgICB4Qm9keSAgICA9IHhCb2R5OiIgXG4iOnBtTDc7DQoJCSAgICAg
ICAgICAgICB4Qm9keSAgICA9IHhCb2R5OiIgXG4iOnBtTDg7DQoJCSAgICAgICAgICAgICB4Qm9k
eSAgICA9IHhCb2R5OiIgXG4iOnBtTDk7DQoJCSAgICAgICAgICAgICB4Qm9keSAgICA9IHhCb2R5
OiIgXG4iOnBtTDEwOw0KCQkgICAgICAgICAgICAgeEJvZHkgICAgPSB4Qm9keToiIFxuIjpwbUwx
MTsNCgkJICAgICAgICAgICAgIHhCb2R5ICAgID0geEJvZHk6IiBcbiI6cG1MMTI7DQoJCSAgICAg
ICAgICAgICB4Qm9keSAgICA9IHhCb2R5OiIgXG4iOnBtTDEzOw0KCQkgICAgICAgICAgICAgeEJv
ZHkgICAgPSB4Qm9keToiIFxuIjpwbUwxNDsNCgkJICAgICAgICAgICAgIHhCb2R5ICAgID0geEJv
ZHk6IiBcbiI6cG1MMTU7DQoJCSAgICAgICAgICAgICB4Qm9keSAgICA9IHhCb2R5OiIgXG4iOnBt
TDE2Ow0KCQkgICAgICAgICAgICAgeEJvZHkgICAgPSB4Qm9keToiIFxuIjpwbUwxNzsNCgkJICAg
ICAgICAgICAgIHhCb2R5ICAgID0geEJvZHk6IiBcbiI6cG1MMTg7DQoJCSAgICAgICAgICAgICB4
Qm9keSAgICA9IHhCb2R5OiIgXG4iOnBtTDE5Ow0KCQkgICAgICAgICAgICAgeEJvZHkgICAgPSB4
Qm9keToiIFxuIjpwbUwyMDsNCgkJICAgICAgICAgICAgIHhCb2R5ICAgID0geEJvZHkgOiAiIFxu
IFxuIFxuKioqIERhdGFTdGFnZSAtIENvYnJhbnphcyAqKioiOw0KCQkgICAgICAgICAgICAgKg0K
CQkgICAgICAgICAgICAgcmMgPQ0KCQlEU1NlbmRNYWlsKHhGcm9tOiJcbiI6eFRvOiJcbiI6eFN1
YmplY3Q6IlxuIjp4U2VydmVyOiJcbiI6eEJvZHk6IlxuIik7DQoJCSAgICAgICAgICAgICAqDQoJ
CSAgICAgICAgICAgICBJRiByYyA8PiAiMCINCgkJICAgICAgICAgICAgIFRIRU4NCgkJICAgICAg
ICAgICAgICAgIENBTEwgRFNMb2dGYXRhbCgiRXJyb3IgZW4gZWwgRFNTZW5kTWFpbC4iLCJNU0ci
KTsNCgkJICAgICAgICAgICAgICAgIEFucyA9ICJFUlJPUiI7DQoJCSAgICAgICAgICAgICBFTkQN
CgkJDQoJCQ0KCQkgICAgICAgICAgICAgR3VpbGxlcm1vIFAuIEJhcnNreSAtIGdiYXJza3lAb3Nk
ZS5jb20uYXINCgkJICAgICAgICAgICAgIEdlcmVuY2lhIGRlIFNpc3RlbWFzIC0gRGVzYXJyb2xs
bw0KCQkNCgkJDQoJCQ0KDQo=

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

_________________
PLEASE READ
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Wed Feb 18, 2004 10:25 am Reply with quote    Back to top    

Alex:

The routine is called from a batch job. You need to declare the routine
with this sentence:
Deffun
DSU.SendMail(To,Subj,Import,L1,L2,L3,L4,L5,L6,L7,L8,L9,L10,L11,L12,L13,L14,L15,L16,L17,L18,L19,L20);

And to call it, use this subroutine:

MandaMail:
*
* Fill in all fields
*
rc =
DSU.SendMail(xTo,xSubject,xImportancia,xL1,xL2,xL3,xL4,xL5,xL6,xL7,xL8,xL9,xL10,xL11,xL12,xL13,xL14,xL15,xL16,xL17,xL18,xL19,xL20);
IF rc "OK"
THEN
Call DSLogWarn("** Error al enviar el mail para ":xTo:" por el tema
":xSubject:".", "CHKSAP");
END
*
Return;


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: ENC: RES: trigger email
@oliver.com


18/02/2004 09:07 a.m.
Por favor, responda a
DataStage Users
Discussion List






Guilllermo,

and from where do you call your routine?
Tks,
Alex

-----Mensagem original-----
De: gbarsky@osde.com.ar
[mailto:gbarsky@osde.com.ar]
Enviada: ter 17/02/2004 15:38
Para: DataStage Users Discussion List
Cc:
Assunto: Re: RES: trigger email







Alex:

Really I don't know what to tell you. Remember
that the code I gave you is
within a routine. I don't know if this is
important, but....


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: "DataStage Users Discussion List"

Enviado por:
cc:

datastage-users-bounces
Asunto: RES: trigger email

@oliver.com





17/02/2004 02:33 p.m.

Por favor, responda a

DataStage Users

Discussion List









Guillermo,
I notice the way you define a function:

Deffun DSSendMail(A);

I can´t run a job control here that have this:

Deffun UHashLookup(A1, A2, A3) Calling
"DSU.UtilityHashLookup"
P_DATA_INICIAL =
UHashLookup("HSH_MAX_CORDW082",1,1)

It gives no message, but attributes no value to
P_DATA_INICIAL either.
Could you help me with this too?

Muchas gracias,
Alex

-----Mensagem original-----
De: gbarsky@osde.com.ar
[mailto:gbarsky@osde.com.ar]
Enviada: ter 17/02/2004 14:10
Para: datastage-users@oliver.com
Cc:
Assunto: Re: trigger email







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




_______________________________________________
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

_________________
PLEASE READ
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours