Can you please help me in converting VARCHAR () BIT DATA to INTEGER.
Eg: DECLARE tempvar VARCHAR(4) FOR BIT DATA.
This contains value x'00005721',
This needs to be converted as
(5*16^3)+(7*16^ 2)+(2* 16^1)+(1* 16^0) = 22305 (Integer)
Is there a function in db2 which supports this?
Eg: DECLARE tempvar VARCHAR(4) FOR BIT DATA.
This contains value x'00005721',
This needs to be converted as
(5*16^3)+(7*16^ 2)+(2* 16^1)+(1* 16^0) = 22305 (Integer)
Is there a function in db2 which supports this?