DSXchange

Hi Gurus,

How can I deal with job parameters in production environment,since these parameters doesn't have default value.I means project level parameters can be assigned default values like $projdef, but joblevel parameters cannot be assigned, in that case how to deal with these parameters.

cheers;
vijay

vijaykumar wrote:joblevel parameters cannot be assigned, in that case how to deal with these parameters.

You can give default values for Job parameters. This is at the job level.
You can also set the default values in the Datastage Director.

Hi Gurus,

Is there any way of identifying the project level parameters and job level parameters.I mean to can by seeing the parameter declaration can we identify whether its joblevel or project level.

#$param# = project level parameter
#param# = joblevel parameter.

am i going in the right way.

cheers;
vijay

vijaykumar wrote:#$param# = project level parameter
#param# = joblevel parameter.

That right

Hi Gurus,
I have searched the forum, and i found that there are several ways of declaring parameters.

one is through administratior- projectlevel parameters.
the other one is through sequencer assigning parameters and then allocate it to job activity.
The other way is .ini file and using dsset param.
I want to find the actual way of parameter.

$projdef---> the approach may differ , but i think the original value is stored in the dsparam file only.Am i going in the right way

vijaykumar wrote:I want to find the actual way of parameter.

There is no actual(strict) way.
You can do it as per your requirement

Not sure which file the original/default value of the Environment variables is stored in.

Hi Gurus,
One of my friend was saying that the actual way of the parameter is stored in DSPARAM file strictly.

when i declared at administrator, i could find actual way of parameters in DSPARAM FILE.
what abt when declared using .ini file and ds.param function.
My first question is can we declare any parameter in this way(using dsparam function)
#$username#,#$password#
Actually is there any other files that has these actual values.can u please list few files where there are chances of finding actual value of parameter

cheers;
vijay

Are you referring to DSParam file. Its present in the your project directory.

Get some more knowledgable friends.

The name of the file is DSParams, and the only job parameters stored there are those set up as environment variables in the Administrator client. Other parameters are properties of the job or shared container, and therefore are stored in the DS_JOBOBJECTS table in the Repository. And any environment variable whose value is obtained via the $ENV default is not stored at all; it's obtained from the user's operating system shell.

There is NO function called DSParam().

ray.wurlod wrote:Get some more knowledgable friends.

Dang, beat me to it.

Hi Gurus,
Thanks very much.
where is this DS_jobobjects table, i can't find in my repository.Is this visible in my repository branch or shall i use the administrative command inorder to access this table.

please help me.

cheers;
saama

Saama wrote: shall i use the administrative command inorder to access this table.

Right.

Keep in mind, it is case sensitive - DS_JOBOBJECTS

What do you want to get from DS_JOBOBJECTS pertaining to parameters?