Posted: Wed Sep 18, 2002 2:04 pm
You need to define a parameter in the second job to hold the variable and then use 'DSSetParam' in your controlling batch before running the job. From the help:
Syntax
ErrCode = DSSetParam (JobHandle, ParamName, ParamValue)
Example
The following commands set the quarter parameter to 1 and the startdate parameter to 1/1/97 for the qsales job.
paramerr = DSSetParam (qsales_handle, "quarter", "1")
paramerr = DSSetParam (qsales_handle, "startdate", "1997-01-01")
(ParamValue can also be a variable)
-craig
Syntax
ErrCode = DSSetParam (JobHandle, ParamName, ParamValue)
Example
The following commands set the quarter parameter to 1 and the startdate parameter to 1/1/97 for the qsales job.
paramerr = DSSetParam (qsales_handle, "quarter", "1")
paramerr = DSSetParam (qsales_handle, "startdate", "1997-01-01")
(ParamValue can also be a variable)
-craig