Hi there,
I have a DB2 6 database on our system which our program uses.
The id is stored as a CHARACTER length 8, LOB unit= "bytes" with
"bit data" checked on.
When I select the ID which is the primary key I get this value:
x'1D00000000001B65'
Is there a way to convert that value into an integer ?
Actually the character in the field is composed of 8 bytes, in this example it´s 1D 00 00 00 00 00 1B and 65
I need to move 1D to the back of the forth byte -> 00 00 00 1D and convert this to decimal using hex2dec 🙂
