Dynamic Parameter

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
S.reddy
Participant
Posts: 1
Joined: Thu Jul 02, 2020 11:28 am

Dynamic Parameter

Post by S.reddy »

Hi all,

How do we set parameter value by reading the value from Database? This is useful when the config table related to Job is in Database and want to update table or read the table to assign it to parameter.

Regards,
Srini.
Srini
jackson.eyton
Premium Member
Premium Member
Posts: 145
Joined: Thu Oct 26, 2017 10:43 am

Post by jackson.eyton »

I don't believe this is possible directly within a parallel job. I do this using Sequence jobs and UserVariable Activity stages. From what I understand of your need, you'd want a parallel job that performs your database query and outputs the result to a file, then using a UserVariable Activity stage, execute a ReadFile routine to pull the value from the file and store it in a variable. Then in the same sequence execute the parallel job which you have that "Dynamic" parameter and set the parameter value as the UserVariable.
-Me
Post Reply