Job parameter question

[ririr]

I have the following DS job design. DRS stage type is used for reading and writing data between the Source and the Target

Source--------->Transformer-------------Target

Parameter BUSINESS_DATE (DATE) is passed as date to the job and is being used in the transformer to map to a target column EFFECTIVE_DATE (DATE).


I have the folowing code in the job control window of the job.

BusinessDay=Oconv(( @DATE ) , "D-YMD[4,2,2]")
ParamName = "BUSINESS_DATE"
ParamValue = BusinessDay
ErrCode = DSSetParam(hJob, ParamName, ParamValue)

The parameter value is not getting changed dynamically, the job still uses the default value of the BUSINESS_DATE parameter, which is a dummy date(01-01-1900).

Any help is appreciated

[kcbland]

A job cannot change its own parameter values during runtime. The job control tab is used to control other jobs.

Search this forum, we've covered job control and job parameters ad nauseum. If you which to feed job parameters, use the controlling Sequence, Batch, or command line options under dsjob to feed in the appropriate values.

If you don't use job parameters, you can investigate macros for things like filenames, but in the case you suggest, you can use a Stage variable and for the initialization value use OCONV(@DATE,'D-YMD[4,2,2]'). Then use the Stage variable as the derivation.