DSXchange

Hi,
In my seqfile One field value is '000'and in my lookuphash file field value is '0'. SO when it is trying to lookup. it will fail.

How to solve this problem.
any help would be appreciated.

TIA

to field in seq file use

(linkname.seq_field_name + 1 - 1)

this will convert it to 0 which will then match with the lookup

gpatton wrote:to field in seq file use

(linkname.seq_field_name + 1 - 1)

this will convert it to 0 which will then match with the lookup

I think you mean in the key expression where you do the lookup use:

Thank you

gpatton wrote:to field in seq file use

(linkname.seq_field_name + 1 - 1)

this will convert it to 0 which will then match with the lookup

Note the change Ken made to the key expression logic. Any kind of 'math' on the field will (in essence) convert it to a number. So do something that you know won't change the value of the field - like adding zero to it - rather than adding and subtracting 1 from the value.

Both work and illustrate the point, the zero is 'safer' and fewer operations.