I guess the answer to the original question is the HEX function
which was already mentioned.
Regarding FOR BIT DATA: because you have CHAR strings
and packed decimal data in one column, you will not be able
to cross platform boundaries anyway. If you do conversions,
your decimal data will be garbage, and if you don't, you will
get EBCDIC chars on ASCII machines etc.; so you need to make
sure that there will be no code translations, no matter if there is
a FOR BIT DATA clause on the column or not.
To put the different data in one column is really a very bad idea ...
Kind regards
Bernd
Am 06.05.2014 22:21, schrieb R.R.:
>
> Mark,
>
> Thanks. I'll try FOR BIT DATA and let you know.
>
> R.
>
>
> -----End Original Message-----
|