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.
Pass values from one job to another
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 385
- Joined: Tue Oct 07, 2003 4:55 am
Hi,
you can use the user status returned by the first job.
write yourself a routine that looks like this:
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
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
the 2nd job will accept as a parameter job1.$UserStatus and use it in the sql .... where x_date between #date_param#
HTH
amos
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: