how to pass before job subroutine's return value to a job

[savis]

Hi,

I want to fetch the max value from a table and use (max+1) as the satart value field in a surrogate key generator stage.

I thought of writing a script which retrieves the max value.

But how can i pass this value from script to the job?

Thanks,
Savis

[ray.wurlod]

Set the value returned from the script in a job parameter.

[kduke]

Ray is telling you it can't be done. You need to run the routine first. You can easily do this in a sequence. Next run your job and feed the return value in one job parameter.