How to pass values for Parameter set to Dsjob

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
Althaf6553
Participant
Posts: 64
Joined: Wed Sep 26, 2007 6:52 am
Location: Syracuse ,NY

How to pass values for Parameter set to Dsjob

Post by Althaf6553 »

Hi,

I want to pass values for parameter set from dsjob command.
I have a parameter set named param_set and I have 4 parameters in the parameter set param_set.
I want to store values for these 4 parameters in a file and I want to send this file as a parameter to the dsjob command using
"dsjob -run -param param_set = valuesfilename -projname -jobname"

but I am getting error like unable to load values for parameter set parm_set.

Any one please help me out in resolving this issue.
Please explain me is there any ristriction for creating values_file like .txt and so on. How we have to provide values for parameters in a file.

parameter name (then give tab) and value for parameter or
just values are enoough without giving parameter name.

Please let me know .
Althaf
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I honestly don't know but if you've got the syntax right it wouldn't have spaces around the equal sign. Try "-param param_set=valuesfilename" instead.
-craig

"You can never have too many knives" -- Logan Nine Fingers
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

chack that the parameter file exists with the proper parameters and values
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
Althaf6553
Participant
Posts: 64
Joined: Wed Sep 26, 2007 6:52 am
Location: Syracuse ,NY

How to pass values for Parameter set to Dsjob

Post by Althaf6553 »

But I am not sure how we have to provide values for parameters in the value file.

is it like

paramset.parameter_name (press tab) provide value
or
just

parameter_name value (without paramset. before param_name)

please clarify how we should define values in the value_file.
Althaf
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
Parameter set file consists of pairs in the form of:

Code: Select all

param_name=param_value
each parameter is written in a new line
I think it is located in the project folder (the project your jobs run under) a quick search should locate it's position, depending on the location it was saved inside the repository.

IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Option -param=parametersetname=valuesfilename will work. The individual parameter values, in this case, have been pre-stored in the values file.

If you want to override one of these "default" values, the proper syntax is then -param parametersetname.parametername=value
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Parameter sets in each project have a default value file associated with them, do they not, assuming you've set that up? If that's the case there's no reason to pass anything from the command line unless you need to override the job to use a different value file for the run, I would assume.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You edit the values files within the Parameter Set itself. Each values file contains a set of "default" values to be used if that particular values file is selected as the "value" of the Parameter Set job parameter (the first syntax I suggested earlier).

Refer to the webinar broadcast earlier this year (from http://www.dsxchange.net) on parameter sets.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

So... you have to specifically tell it to use a particular values file at run time each time? There's no concept of a default 'always use this file' file here?
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Yes there is. A Parameter Set contains a "default default" set of values as well as zero or more values files.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Althaf6553
Participant
Posts: 64
Joined: Wed Sep 26, 2007 6:52 am
Location: Syracuse ,NY

Re: How to pass values for Parameter set to Dsjob

Post by Althaf6553 »

Thanks to all for your responses. I have solved the issue.
Thanks once again.
Althaf
Post Reply