Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
In the case you give (25369 vs 54879), the records would be considered unmatched.
However, you really need to consider the matching PD values to understand if CH would work for you or not.
If your packed decimal fields are "normalized", then the comparisons will work correctly with CH format. If the packed decimal fields are "not normalized", then you'd need to use separate ON operands for the CH and PD fields.
By "normalized", I mean that all of the positive PD values have the same sign (e.g. C) and all of the negative PD values have the same sign (e.g. D).
An example of "not normalized" PD values would be where some of the positive PD values have a C sign and some of the positive PD values have an F sign. |
|