is the any possible of passing parameter value

Tej · Posted: Thu Jan 22, 2009 3:06 am

Hi,

can any one help me in the below concern issue,
is there any possible of passing parameter value from one job to another from sequencer level or other way.

please help!!!

Thanks in advance!!!

kandyshandy · Posted: Thu Jan 22, 2009 9:31 am

what are you trying to achieve? It is possible but after reading your requirements...

chulett · Posted: Thu Jan 22, 2009 10:09 am

You need to be more specific. Sequence jobs easily handle parameters across multiple objects, jobs included. Other ways exist. What are you trying to accomplish and what specific issue are you having?

Tej · Posted: Fri Jan 23, 2009 2:06 am

can i pass the paremeter value from one to the other in the sequencer

ray.wurlod · Posted: Fri Jan 23, 2009 3:18 am

No, but you can pass a parameter value from one activity to another in a job sequence. (A sequencer is a component that may occur IN a job sequence.) If this is a top level parameter - that is, ...

What's this?

chulett · Posted: Fri Jan 23, 2009 8:34 am

As noted, if you've got the parameter in the Sequence to pass to the first activity, simply pass that same parameter to any other activity as well.

kandyshandy · Posted: Fri Jan 23, 2009 9:17 am

I guess Tej's scenario is like this...

First job activity outputs something which should be passed as a parameter to the second job activity.

Tej, you need to be more clear in asking questions here.. otherwise our answers will be unclear too. Tell us what you are trying to do exactly and then you will get right answers.

mk_ds09 · Posted: Mon Jan 26, 2009 4:01 am

Tej..

are you trying to say that you want ot pass the values from one sequencer to other sequencer..

if the value are static one..then you can create a file which can be read by the both of the jobs and then these values can be used..

if the second sequncer is using the values that are depenedent on the first one..then you need to create the parametr file in the first sequence ..and then these values can be used in the second sequence..!

........
this is one of the scenario...

if you want ot have the values in the just one sequence ..then pass all the parameters to the sequence..and these values can be used by all the jobs within the sequence..

-------------------

one more thing..that most of the people already told..
if you need some help on some of the topic..try to understand the people who are reading the posts not at all related to your requirement..
read the post again form the user point of view...
try to put maximum details..so that other person can understand and can reply on that..

-----------------------

hope this helps ..

--------------
MK

shamshad · Posted: Mon Jan 26, 2009 8:57 am

I assume what Tej needs has been already answered by MK.

If you are processing some logic in the first Sequence/Job and the result of the first Sequence needs to be passed to the Second Sequence, then store all the parameter name and value pair from the First Sequence in a sequential file. Then in the second Master Sequence read those parameters and its values.

If you are executing your DS job via UNIX Shell Script then in the UNIX script of the second master sequence you can read the sequential file (that was created)

Below is an example

(1) Content of the parameter file that was created from First Seuence
xx_tddbname=TACOM_DATA
xx_tstgname=TACOM_STAGING_DATA
xx_tlogname=TACOM_SUPT_DATA

(2) Now read the above file and pass these 3 parameter in Second Seq.

#!/bin/sh
. /company/proj/Ascential/Projects/TACOM_DEV/paramfiles/paramfiles.txt
# DataStage Parameter Processing:
cd $DSHOME
cd `cat /.dshome`
. ./dsenv
bin/dsjob -run -mode NORMAL \
-param 'tddbname'=$xx_tddbname \
-param 'tstgname'=$xx_tstgname \
-param 'tlogname'=$xx_tlogname \

(You can see the value of the parameter file are being passed to the Second Master Sequence)

chulett · Posted: Mon Jan 26, 2009 9:25 am

shamshad wrote:

I assume what Tej needs has been already answered by MK.

I would make no such assumption, especially considering the questions asked so far and the shear amount of guessing going on in what is being posted. Confused

shamshad · Posted: Mon Jan 26, 2009 9:37 am

chulett wrote:

shamshad wrote:

I assume what Tej needs has been already answered by MK.

I would make no such assumption, especially considering the questions asked so far and the shear amount of guessing going on in what is being posted. Confused

When the question is not very clear and we sort of know what he means I guess we can atleast write our responses and try our best to help unless the question is rephrased again Rolling Eyes