How to assign parameter a value

Billyqing · Post by **Billyqing** » Fri Jun 08, 2012 12:09 pm

At my job design, I have to assign parameter a values. This value will be passed to the down stream jobs.

What is the best way to do so?

Thanks in advance.

pandeesh · Post by **pandeesh** » Fri Jun 08, 2012 12:16 pm

use a parameter and pass the same to downstream jobs.

jwiles · Post by **jwiles** » Fri Jun 08, 2012 12:26 pm

Well....

1) Use a job sequence, give it the parameter and pass that parameter to jobs/sequences called by the master sequence
2) Use a parameter set containing the parameter
3) Use a combination of 1 and 2 above

Regards,

Billyqing · Post by **Billyqing** » Fri Jun 08, 2012 12:56 pm

Thanks for your feedback.

My question is how to assign a values to the parameter which will be used to passed to down stream jobs.

The value is dynamic selected from DB table.
The way I am current used is not good enough, my opinion at least.
So I am looking for the best one.

Thanks

chulett · Post by **chulett** » Fri Jun 08, 2012 1:07 pm

1) Use a Server job to fetch the parameter value.
2) Write the parameter value to the job's USERSTATUS area
3) Assign all downstream job parameter values to $UserStatus from the Server job.

You'll need to build a little routine to call the DSSetUserStatus function but the code for that can be found here. Another option is to write the value to a flat file then use a routine or command to 'read' it and then assign the output from that to any downstream job parameters.

What is your current methodology?

Billyqing · Post by **Billyqing** » Fri Jun 08, 2012 1:50 pm

Thank you, Craig.

My current approach is to select the results from a DB table and write the results into a file. Then using a function to get the value from the file just saved. Finally pass the parameters into down stream jobs.

Hope this is clear to you.

jwiles · Post by **jwiles** » Fri Jun 08, 2012 1:59 pm

A modification of the file method which would also work:

You can write the value to a parameterset valuefile in the form of PARAMETER=VALUE, then pass that parameterset, using the valuefile name, to a child sequence which calls your jobs.

Regards,

Billyqing · Post by **Billyqing** » Mon Jun 11, 2012 7:10 am

Could the host of forum move this post into DataStage PX forum?

Thanks,

chulett · Post by **chulett** » Mon Jun 11, 2012 7:20 am

If I felt this discussion was something specific to the PX product, I would have moved it already.

This is a perfectly appropriate General topic. Carry on!

joycerecacho · Post by **joycerecacho** » Wed Sep 26, 2012 10:53 am

chulett wrote:1) Use a Server job to fetch the parameter value.
2) Write the parameter value to the job's USERSTATUS area
3) Assign all downstream job parameter values to $UserStatus from the Server job.

Hi everybody.
I have the same issue.
How do I use a Server job to fetch the parameter value?

Thank guys!

Best regards,

chulett · Post by **chulett** » Wed Sep 26, 2012 1:23 pm

Thought you weren't allowed to use Server jobs? If this case 'fetch' just means 'read from' because the parameter was stored in a database table.