So it sounds like you're suggesting I somehow change the declaration
of the field in my files to BINARY. Can I do that in the DDS? Can I
do it with some sort of a CHG or ALTER TABLE?
CRPence on Friday, October 19, 2012 10:54 AM wrote:
On 19 Oct 2012 10:46, CRPence wrote:
I suppose a likely problem origin is for use of CCSID 37 instead
of FOR BIT DATA; the collation [Sort Sequence] would be moot for
the kind of issue I am thinking of.<<SNIP>>
Actually the use of CHAR, even with FOR BIT DATA, would likely
suffer the same type of problem I alluded. That is to suggest,
even the declaration of CHAR FOR BIT DATA is still
"character-string" data for which the blank-pad character changes
between encoding choices ASCII vs EBCDIC. Thus I presume the data
type to support 8-byte unsigned integer *must* be BINARY... which I
expect the database key processing *must* *never* infer any
pad-character to be used for comparisons.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.