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?
rangasudhakar
Last Activity: Jul 28 '08, 12:13 PM
Joined: Jul 28 '08
Location:
-
Function to convert for bit data column / field to INTEGER?
-
Function to convert for bit data column / field to INTEGER?
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?
No activity results to display