DSXchange

Posted: **Tue Nov 23, 2004 9:36 am**

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.

Posted: **Tue Nov 23, 2004 10:27 am**

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

Posted: **Tue Nov 23, 2004 2:24 pm**

Thank you so much.

Posted: **Wed Mar 29, 2006 12:33 pm**

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

Posted: **Wed Mar 29, 2006 2:56 pm**

Anything you like

DSXchange

Pass values from one job to another

Pass values from one job to another