Page 1 of 1

Job parameter

Posted: Fri Sep 02, 2011 12:18 pm
by kennyapril
I was passing job parameter which is RUNDATE and the datatype is String used in the parameter, but this parameter is used for jobruntime in the parallel job. In the sequence of this job the parameter is been given value in the uservariable stage as DSjobruntimeStamp. Finally when I run the sequence it should read the dsjobruntime and send it to the parallel job which sends it to the target. AS the datatype given is string in the job parameter for RUNTIME the sequence job fails as we are sending the time stamp.

In the parallel job this string has been converted to timestamp but the dsjobruntime is not coming to the job parameter.


Please suggest any changes

Posted: Sat Sep 03, 2011 2:29 am
by ray.wurlod
Check the name of the DataStage macro. I think it's actually DSJobStartTimestamp.

Note, too, that DataStage macro names are case sensitive.