DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
S.reddy
Participant



Joined: 02 Jul 2020
Posts: 1

Points: 8

Post Posted: Sun Jul 05, 2020 4:56 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Windows
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



Group memberships:
Premium Members

Joined: 26 Oct 2017
Posts: 143

Points: 2340

Post Posted: Tue Jul 07, 2020 6:25 am Reply with quote    Back to top    

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
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours