I need to unload data from an imagecopy specifying a hex value for a selected column.
What is the syntax for selecting a hex column?
Select pit_rba , hex(pit_rba) from sysibm.syscopy
where hex(pit_rba) = '000067EAC685'
I'm not sure if it works on an UNLOAD as I haven't played on a mainframe for some time, but this should work if standard SQL is supported:
colname = x'001234FF'