DSXchange

Posted: **Thu Apr 28, 2005 3:28 am**

Hi everybody,

We have 2 hash files.And 1 Oracle Stage.

I want to pass Hash1 Arr_Id and Hash2 Bill_date to Oracle Oci stage as a dynamic parameter.

So query will be like below

Select sum(Tram_amt)
from t1
where arr_id=&Hash1_Arr_id
and dt=&Hash2_Bill_date

Thanks & Regards,
Narendra

Posted: **Thu Apr 28, 2005 3:47 am**

Best will be to split them as 2 jobs. First obtaining the values and the next passing to OCI as params. You may need a third to cover both.

Posted: **Thu Apr 28, 2005 4:03 pm**

So the query will look like:

Code: Select all

Select sum(Tram_amt) 
from t1 
where arr_id=#Hash1_Arr_id# 
and dt='#Hash2_Bill_date#'

You can use job parameter references even in generated SQL. You can also use aggregate functions such as SUM (in Derivation in the Columns grid) in generated SQL.

DSXchange

Dynamic parameter passing to OCI Stage

Dynamic parameter passing to OCI Stage