DSXchange

Hi

I have a job like this.

Source1: Sequential File contains two columns ( A, B )
Source2: DB2 Table contains 4 columns ( A1,B1,C1,D1 )
Lookup: Source.A = Source1.A1
( Condition Not Met: Continue
Lookup Failure: Reject )

Source1: Integer type data 67219
Source2: Char type data contains Numbers ( 000000001 )

Target is Sequential File.

My goal is if Source1.A = Source2.A1 then take the output as Source1.B
But i am getting only first value from Source1.B


My job is working fine.

Please explain me what is my mistake in Lookup

Thanks
SReddy

Have you enabled "multiple row return from reference input"?

Thank you Ray

I tried by enabling Multiple rows returend from link. Still i am getting same.

I tried the same job using Join stage. But data is same.

---------------------------------
69613---1---0003---4---14
69613---1---0006---8---14
69613---1---0007---6---14


Please help me what i have to do.

Thanks
SReddy

can you please rephrase your problem statement as its not descriptive enough for me and give example including input and output.

Source1 : Sequential File contains two columns ( A, B ) -- Reference Data
Source2 : DB2 Table contains 4 columns ( A1,B1,C1,D1 )
Lookup: Source.A = Source1.A1
( Condition Not Met : Continue
Lookup Failure : Reject )

Source1 : Integer type data 67219 -- Reference Data
Source2 : Char type data contains Numbers ( 000000001 )

Target is Sequential File.

My goal is if Source1.A = Source2.A1 then take the output as Source1.B
But i am getting only first value from Source1.B


Thanks
SReddy

can you put some example of source1 and source2 data. and what is you are expecting in the output