Unload from imagecopy selecting hex value

william giannelli

Unload from imagecopy selecting hex value

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?

thanks

Bill

alain pary

RE: Unload from imagecopy selecting hex value
(in response to william giannelli)

Hello 

very simple 

Select pit_rba , hex(pit_rba) from sysibm.syscopy
where hex(pit_rba) = '000067EAC685'

 

Alain

Greg Palgrave

RE: Unload from imagecopy selecting hex value
(in response to william giannelli)

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'

Cheers

Greg