how to fetch one custid associated with multiple processids.
Posted: Thu Sep 03, 2009 11:26 pm
Hi
I have table with
processId CustId
1 z101
2 z101
3 z102
4 z103
1 z103
I want for each custId ---- corresponding ProcessIds should be taken.
Ex: for z101----- ProcessIds are 1,2
I have further codings with that each processId values.
this something like a nested for loop in C Coding
For(..)
{
for(..)
{ ----}
}
how to implement this in either dB2 query or in datstage..
Plz help me to resolve this.
Any help is appreciated..
thanks in advance..
I have table with
processId CustId
1 z101
2 z101
3 z102
4 z103
1 z103
I want for each custId ---- corresponding ProcessIds should be taken.
Ex: for z101----- ProcessIds are 1,2
I have further codings with that each processId values.
this something like a nested for loop in C Coding
For(..)
{
for(..)
{ ----}
}
how to implement this in either dB2 query or in datstage..
Plz help me to resolve this.
Any help is appreciated..
thanks in advance..