default values of jobparameters

[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

[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.

[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.

[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.

[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"
;