Just recently in DB2 9.7.5 we introduced the HEXTORAW function. This function converts a hex-string into a VARCHAR FOR BIT DATA and is thus the inverse of the HEX function. But is it really? Not quite. the HEX function dumps the internal representation of all sorts of types, not just strings. So the question arises: How hard would it be to add other conversion functions which re-constitute values from their hex-dump? Perhaps I'll write a little library and publish it here in the near future, but for now let's look at one such function only:...

[More]
Tags:
hex
ccflags
hextoraw
sql_ccflags
hextoint
little-endian
big-endian