I am using AS400/DB2 V5R1.

I have column in a table whose data is in Hexadecimal. I would like to convert the same to a char and I am not able to.

If I have a literal string I am able to convert using char(x'ffff'). The same is not the case when I try to convert the values in a column.