UNHEX returns a character string that is the decoded value of a hex input string.
>>-UNHEX(x-+----+-)-------------------------------------------->< '-,c-'
- x
- An expression that must have CHARACTER type.
- c
- An expression that must have CHARACTER(1) NONVARYING type. If specified, it is the character that separates every 8 characters in x.
UNHEX(x) is the reverse of HEX(y), and UNHEX(x, c) is the reverse of HEX(y, c).
If x contains non-hex characters, the CONVERSION condition will be raised.