Import delimited hexadecimal or binary data to "varchar for bit data" columns

[earsypaul]

Hello,

With MS SQL server we can bcp hexadecimal data into varbinary columns
quite nicely. We're migrating some data to DB2 and trying to import to
a "varchar for bit data" data type column. With delimited data it looks
like importing binary data is not an option as the binary data might
have LFs, CRs etc and the import tool will get confused as to where the
columns and rows begin or end. The DELPRIORITYCHAR modifier does not
appear to help in this case.

It appears that the import tool will not accept hexadecimal data for
import into "varchar for bit data", it interprets the data litterally
(as varchar when converting it to "varchar for bit data"). I've tried
formatting the input with x'hex_data_is_here' but this doesn't work in
trying to trick it.

Am I missing something? Any suggestions?

Thanks!

Paul