DSXchange

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

Kiran,

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


________
Anupam

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.

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