Lookup output AS as parameter

[vskr72]

I have a lookup table which has a structure like this:

Code: Select all

Ref_File        Master_File
----------       -------------
a.txt              Ref_a.txt 
b.txt              Ref_b.txt 
c.txt              Ref_c.txt 

hen I lookup onthe table a.txt, the output is Ref_a.txt. I want to use this value as a parameter and pass it to a seq file stage which will fetch the data from actual file present in a directory whose name is Ref_a.txt. Pls suggest me how to handle this. Thank you

[pandeesh]

1)In first job ,lookup and write the value to a temporary file

2)use

Code: Select all

cat temp_file

in execute command activity and pass the

Code: Select all

$commad.output

as parameter to next job. Pass this parameter to filename in seqfile stage.

IHTH

[srinivas.g]

write the shell script. inside the shell script--> call toe sql select statement
and pass the value to the next job.

select master_file from lookup_table where ref_file='a.txt'.

[mgsteiner]

You can create a routine to set the $UserStatus variable to pass a parameter value out of that job to another:

Code: Select all

FUNCTION UpdateUserStatus(Arg1) Call DSSetUserStatus(Arg1) Ans = Arg1