Range lookup droping values or not getting values from refer
Posted: Mon Jun 04, 2012 11:46 am
/*ds version 8.7*/
/* reference : sequential file*/
The following my scenario
I'm getting ZIP5, ZIP4 from source(CASS output) need to implement range operation on reference file which has ZIP5, ZIP4_Low_Range and ZIP4_High_Range.
All the columns datatype is varchar
I'm implementing the following scenario in lookup condition:
Input.ZIP5 = Reference.ZIP5(Equality)
Range condition:
Input.ZIP4 >= ZIP4_Low_Range
AND
Input.ZIP4 <= ZIP4_High_Range
Even though there is values in reference It's dropping/not bringing the values from reference file.
I applied trim on both side values too.
Thanks in Advance
/* reference : sequential file*/
The following my scenario
I'm getting ZIP5, ZIP4 from source(CASS output) need to implement range operation on reference file which has ZIP5, ZIP4_Low_Range and ZIP4_High_Range.
All the columns datatype is varchar
I'm implementing the following scenario in lookup condition:
Input.ZIP5 = Reference.ZIP5(Equality)
Range condition:
Input.ZIP4 >= ZIP4_Low_Range
AND
Input.ZIP4 <= ZIP4_High_Range
Even though there is values in reference It's dropping/not bringing the values from reference file.
I applied trim on both side values too.
Thanks in Advance