update the global parameter

[shreera]

I want one job seq calling 3 jobs using global param - job 1 assign value 100, job 2 set the value as 100*2 to the same variable
and job 3 uses 200 value of that variable for processing purpose

all jobs having 2 column like:

CODE,VALUE
A,100
B,200
c,300

job 1 assign value 100, job 2 set the value as 100*2 to the same variable
and job 3 uses 200 value of that variable for processing purpose

i have desing the sequencer job like:

Jobactivity1---->Jobactivity2---->Exe command------>Jobactivity3
In exec command : i hav given this command ( cat tail -1 /datastage/Data/DC-DEV/SequentialFile/ComFileRes1.txt | awk -F "," '{print $2}' /datastage/Data/DC-DEV/SequentialFile/ComFileRes1.txt)

and in Jobactivity3 (value expession: Field(Execute_Command_6.$CommandOutput,',',@FM,1)

Job is finished successfully..but it's execute value as '1'.
In job logs...in exe command
CopyOfFirst_Seq -> (Third_job): Job run requested
Mode (row/warn limits) = 0/0
Generating operational metadata
Job Parameters --->
VALUEPARAM=1
DSJobController=CopyOfFirst_Seq

Plzz help me.


Thanks,
Shreeram Gundu

[qt_ky]

Step through running job1 and 2, then manually run the unix command from the command line to check the output. Can you post the actual unix command and its output? The command you posted doesn't look quite right.

[chulett]

"cat tail"? Just tail. Not that that is your problem, just an observation.

Your expression is probably evaluating as 'true', hence the one. I too would be curious what you get when you run the command manually and what exactly you are expecting to get from it.