RES: Help Need!!!

[admin]

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.

[admin]

Dear Mister Craig,
I have no DSSetUserStatus as a function. We are running DataStage 6.0.0.17
Sincerely,
Alex
-----Mensagem original-----
De: Craig Hulett [mailto:Craig.Hulett@comcast.net]
Enviada em: segunda-feira, 5 de janeiro de 2004 12:11
Para: datastage-users@oliver.com
Assunto: RE: Help Need!!!


Wolfgang had the 'simplest' way to accomplish this with his Option #2 if you
want to use a Sequence job to control your 30 jobs (or a series of jobs) and
not have to write any Batch Control...

Your first DataStage job sources from Oracle and selects (via the stored
function) the year value you want to pass to the other jobs. In the
transformer, make use of the DSSetUserStatus function to pass this value to
the User Status comm area. This job can then write some audit information
out to Oracle or do nothing (write to a junk file, perhaps) depending on
what you deem is appropriate - the important thing is to get the value out
to User Status. Then, any follow-up jobs in the sequencer can have their
'Year' parameter set to the value of Job1.$UserStatus (an option in the
Parameter Helper dialogue box) which the Sequencer will read from the proper
place for you.

-craig

-----Original Message-----
From: Venkat [mailto:nvkuriseti@rediffmail.com]
Sent: Monday, January 05, 2004 12: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.