Explanation
This message is generated when SQL encounters a character string where a numeric value is required. CA Datacom attempted to parse the string as a numeric literal and convert it to the format required, but the value supplied did not meet the required criteria for a conversion attempt. The character string could have originated from a reference to a base-table column, user-supplied literal, procedure variable, procedure parameter, or host-variable. Scalar function arguments are generally found to be the source of the offending values. In the message text, the n is the invalid numeric literal,
given in hexadecimal format.
Note: A -324 message can in some cases be received where -161 INVALID DATA messages were received prior to r11 SP4. The SQLSTATE that equates to this SQL return code is 22018.
User Response
Correct any references to character data where numeric data is required. We recommend that you do not depend on such a conversion, because we do not guarantee to attempt or to continue to make such a conversion in any given situation.
|
Copyright © 2014 CA.
All rights reserved.
|
|