How to use Routine as a parameter in the user defined SQL

[dodda]

Hi,

I have a User defined sql in oracle oci stage which extarcts the values based on begin and end date condition E.g to_char(Begin_date,'YYYY-MM-DD')>=(#prev_month_begin_date#) and to_char(End_date,'YYYY-MM-DD')>=(#prev_month_End_date#).There are 2 routines which calculates the value define in parameter values.I just want to use these 2 routines which calculates the begin date ane end date of previous month as a paratmeter value.Could you please suggest how to use these routines as parameters in sql.

Thanks,
Dodda

[ray.wurlod]

Execute each routine via a Routine activity in a job sequence and use the activity variable $ReturnValue from each to supply the value to the job parameters.

Code: Select all

Routine1 ----->  Routine2 ----->  Job