Page 1 of 1
default values of jobparameters
Posted: Wed Apr 05, 2006 8:44 am
by guieri01
Is there any way to get the default value of a jobparameter from the Documentation Tool tables? Unfortunately, the table DSJOBPARAMETERS
doesn't have a column named "DefaultValue"!
Can we find this info anywhere else?
Thanks for your help
Eric
Posted: Wed Apr 05, 2006 9:42 am
by ArndW
I don't think that this information is stored in the tables. I've used the DSGetParamInfo() routine to get these values and store them elsewhere.
Posted: Wed Apr 05, 2006 9:43 am
by kduke
Eric
http://www.dsxchange.com/viewtopic.php? ... ramDefault should give you the fields you need.
Code: Select all
select
DS_JOBS.NAME JobName,
ParamNames,
ParamDefault
from
unnest DS_JOBOBJECTS on MvParams,
DS_JOBS
where
DS_JOBOBJECTS.OBJNAME = 'ROOT'
and DS_JOBOBJECTS.OBJIDNO = DS_JOBS.JOBNO
order by
ParamNames
;
Modify this script to meet your needs. You need to create the fields in the link above first.
Posted: Wed Apr 05, 2006 4:05 pm
by ray.wurlod
Default values are probably in the child table DSProperties or a similarly-named table. (I don't have access to DataStage at the moment, so can't check.)
Be warned that every job parameter has two default values; a "design time" default, set by the developer, and a "run time" default, set by an Administrator using the Director client.
Posted: Wed Apr 05, 2006 5:12 pm
by kduke
Ray is correct. There is a DSJobProperties table which has some of it.
Code: Select all
SELECT
DSJobParameters.ProjectName,
DSJobParameters.JobName,
DSJobParameters.ParamName,
DSJobParameters.ParamPrompt,
DSJobParameters.ParamType,
DSJobParameters.ParamLength,
DSJobParameters.ParamScale,
DSJobParameters.Description,
DSProperties.PropName,
DSProperties.PropValue
FROM
DSJobParameters
INNER JOIN
DSProperties
ON
DSJobParameters.ParamName = DSProperties.ObjectName
AND DSJobParameters.JobName = DSProperties.JobName
AND DSJobParameters.ProjectName = DSProperties.ProjectName
WHERE
DSProperties.PropName = "Default"
;