Loop in Db2 Stage/Any alternate approach with DS stages
Posted: Tue Aug 06, 2013 3:18 am
Hi All,
Can someone pls shed some light around how to accomplish the below logic in Datastage.
I have an input file with the below values
Input :
---------
P1
P2
P3
I have another DB2 Table where i will have record with P1 value . The input record with value P1 is combined to P2 & P2 is combined to P3 & P3 is combined to P4 in the Db2 table (as shown in the below example)
Input fields
P : P1
-------------
P1 P2
P2 P3
P3 P4
The resultant output I am expecting is as below
O/P
-------------
P1 P4
Any ideas on how to accomplish this is appreciated.
Thanks
Synsog
Can someone pls shed some light around how to accomplish the below logic in Datastage.
I have an input file with the below values
Input :
---------
P1
P2
P3
I have another DB2 Table where i will have record with P1 value . The input record with value P1 is combined to P2 & P2 is combined to P3 & P3 is combined to P4 in the Db2 table (as shown in the below example)
Input fields
P : P1
-------------
P1 P2
P2 P3
P3 P4
The resultant output I am expecting is as below
O/P
-------------
P1 P4
Any ideas on how to accomplish this is appreciated.
Thanks
Synsog