SQL Value as Hex

To get a hex representation of a value the SQL function hex can be used:

select hex('MIHAEL') from sysibm.sysdummy1