I need to pass values of one variable to another job.
by going through previous posts, I got some idea about using DSSetUserStatus .
still I don't understand how to use it.
I have one job say JOB1 which reads record count of the table
job is like this
oraclestage--------------- transformer -------------seqfile
values is assigned to column name COUNT in sequential file.need to pass the value of COUNT to another job.
I got this code from this site.
Code: Select all
FUNCTION userstatus(Arg1)
Call DSSetUserStatus(Arg1)
Ans = Arg1
RETURN(Ans)
userstatus(DSLink113.COUNT )
in the sequence, I have 2 job activity stages
JOB1---------JOB2
I tries to get the value like thi
JOB1.$UserStatus.but it is not returning the value from 1st job
can you please give me any idea
Thanks
Sri