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
How to Pass values from a table to Parameters?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.