Pass values from one job to another

[SonShe]

I would appreciate if any one can please help me with the following:

I have a job where I determine 2 date values. These two dates are goin to be used in the next job. My project uses Oracle 8i as the database. I have a need to use the dates in the where clause like as under:

Select ....... from Table Where Ship_Date between Date1 and Date2.

Date1 and Date2 are being determined in the previous job. Basically it is just a SQL statement that determines these dates.

My question is how do I pass these two dates from Job1 to Job2?

Thanks.

[Amos.Rosmarin]

Hi,

you can use the user status returned by the first job.

write yourself a routine that looks like this:

Code: Select all

$INCLUDE DSINCLUDE JOBCONTROL.H
Call DSSetUserStatus(Arg1)
Ans = 0

and put in it the 2 dates like you want to see it in the sql.

the 2nd job will accept as a parameter job1.$UserStatus and use it in the sql .... where x_date between #date_param#



HTH
amos

[SonShe]

Thank you so much.

[soham296]

hey...can u tell me what to write in that arg1 when u wanna pass something from a output link of a transformer

[ray.wurlod]

Anything you like