How to Pass values from a table to Parameters?

sasikiran · Post by **sasikiran** » Fri Nov 17, 2006 12:53 am

Hi,

We are working on Datastage7.5.1. We have a senario where we have to get the values for parameters from a table.

InDetail:

We have to parameterize the Sourcefile FolderPath, path is stored in one table(tablename :parameters column:Sourcefilepath).

How can we do this? Please help us out.

Thanks for Reply

sb_akarmarkar · Post by **sb_akarmarkar** » Fri Nov 17, 2006 12:58 am

Kiran,

Create 2 jobs call one job from another in transformer by passing agrument filename and Foldername.....

________
Anupam

ray.wurlod · Post by **ray.wurlod** » Fri Nov 17, 2006 7:21 am

You have to get the parameter value from the table. That's one job, that has to store the value somewhere accessible, such as its user status area.

The second job has to be passed two values decoded from that pathname. You could use Field() functions, or FinalDelimitedString() routine - search the Forum - or, ideally, a routine that invokes the !GET.PATHNAME subroutine so that the decoding is platform-agnostic. You can pass the directory path and entryname back as a dynamic array or through user-definable system variables such as @USER1 and @USER2.

The job sequence then uses these results to supply values to the parameters in the second Job activity.

kduke · Post by **kduke** » Fri Nov 17, 2006 7:14 pm

I land them into a hashed file just like this post viewtopic.php?t=105239