Explanation
The values of the index used to satisfy GROUP BY sequence are not in order. This is probably due to mixed sign values for packed or zone decimal values for indexes that are not data type sensitive.
For example, if one of the index columns is defined as zone decimal with SIGN=YES, the unsigned value 1 appears between the signed values 9 and 10.
The current and preceding values are printed in hex preceding this error message in the PXX. (The actual sign of the new value may have been changed from signed to unsigned in this display.)
The SQLSTATE that equates to this SQL return code is 55S09.
User Response
Correct the sign of the values to match the column's definition, or change the index definition to data type sensitive and execute RETIX.
|
Copyright © 2014 CA.
All rights reserved.
|
|