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
Dynamic parameter passing to OCI Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 21
- Joined: Sun Jul 18, 2004 11:32 pm
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
So the query will look like:
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.
Code: Select all
Select sum(Tram_amt)
from t1
where arr_id=#Hash1_Arr_id#
and dt='#Hash2_Bill_date#'
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.