RES: Help Need!!!
Posted: Wed Jan 07, 2004 11:49 am
Dear Mister Wolfgang,
how can I write to an userstatus and, in another job, get it?
Could you please give an example?
Thank you very much,
Alex
-----Mensagem original-----
De: wolfgang.huerter@gerling.de [mailto:wolfgang.huerter@gerling.de]
Enviada em: segunda-feira, 5 de janeiro de 2004 05:33
Para: datastage-users@oliver.com
Assunto: RE: Help Need!!!
Hi Venkat,
you cannot change any parameter after the start of the Job. But if you work
with different Jobs there are several oportunities. Even some beside
parameter, depending what you want to do with the "Year". If you only want
to use it to fill a field you can work with stage variables and datastage
functions.
Thought I don't know precisly what you want to do here a general answer.
(1) You have JobA, which is looking for your year. JobA can write this Year
to a seqeuntial file, a hash file or a relational table. Or you can write it
with a dataStage-function to the userstatus of JobA
(2) You have JobB, which task it is to start your 30 Jobs in a
Batchlanguage. JobB can read from userstatus of JobA or the sequential file,
or hash file or relational table, where relational table is not a good
sugestion because it is very difficult (and when not having the right
ODBC-drivers - specialy in UNIX - impossible) to read from relational tables
with batch language.
That's it.
Have a nice new year.
Wolfgang
-----Original Message-----
From: Venkat [mailto:nvkuriseti@rediffmail.com]
Sent: Monday, January 05, 2004 8:15 AM
To: datastage-users@oliver.com
Subject: Help Need!!!
Hey Gurus,
Happy New Year 2004.
I need your suggestion in DataStage for a logic.
I have one Oracle funcation and it is returning "Year" value everytime. I
want to store this "Year" value in a DataStage parameter itself. Now, After
I store in a DataStage Parameter, I will pass this value to 30jobs. Pls help
in this and Waiting ur Suggestions how to I do this?
Thanx and Regards,
Venkat.
how can I write to an userstatus and, in another job, get it?
Could you please give an example?
Thank you very much,
Alex
-----Mensagem original-----
De: wolfgang.huerter@gerling.de [mailto:wolfgang.huerter@gerling.de]
Enviada em: segunda-feira, 5 de janeiro de 2004 05:33
Para: datastage-users@oliver.com
Assunto: RE: Help Need!!!
Hi Venkat,
you cannot change any parameter after the start of the Job. But if you work
with different Jobs there are several oportunities. Even some beside
parameter, depending what you want to do with the "Year". If you only want
to use it to fill a field you can work with stage variables and datastage
functions.
Thought I don't know precisly what you want to do here a general answer.
(1) You have JobA, which is looking for your year. JobA can write this Year
to a seqeuntial file, a hash file or a relational table. Or you can write it
with a dataStage-function to the userstatus of JobA
(2) You have JobB, which task it is to start your 30 Jobs in a
Batchlanguage. JobB can read from userstatus of JobA or the sequential file,
or hash file or relational table, where relational table is not a good
sugestion because it is very difficult (and when not having the right
ODBC-drivers - specialy in UNIX - impossible) to read from relational tables
with batch language.
That's it.
Have a nice new year.
Wolfgang
-----Original Message-----
From: Venkat [mailto:nvkuriseti@rediffmail.com]
Sent: Monday, January 05, 2004 8:15 AM
To: datastage-users@oliver.com
Subject: Help Need!!!
Hey Gurus,
Happy New Year 2004.
I need your suggestion in DataStage for a logic.
I have one Oracle funcation and it is returning "Year" value everytime. I
want to store this "Year" value in a DataStage parameter itself. Now, After
I store in a DataStage Parameter, I will pass this value to 30jobs. Pls help
in this and Waiting ur Suggestions how to I do this?
Thanx and Regards,
Venkat.