Reason:
Numeric overflow has occurred. The data type shown in the message text is the same as specified in the CREATE TABLE statement. The operation shown in the message text can be ADD, SUBTRACT, MULTIPLY, DIVIDE, or ASSIGNMENT.
If you see, in a PXX report, an error summary for an SQLCODE -4 even though your application succeeded, it means that CA Datacom/DB found it necessary to deal with a WHERE clause predicate that used a literal value larger than the column to which it was being compared. For example, if you had a column defined as a DECIMAL(4,2) but you had a predicate such as decimal_column = 1234567.8, a temporary error would be caused with which CA Datacom/DB would deal so that the application could still succeed. When possible, CA Datacom/DB includes in an RQA an appropriate portion of the oversized literal in order to reduce the number of rows processed. When this occurs, the following message is generated in the PXX following the error summary: RQAPRUNE: PARTIAL LIT USED. You can ignore this message, but because you could be eliminating more rows than you intend from the result set, we recommend that you correct the predicate,
The SQLSTATE that equates to this SQL return code is 22003.
Action:
If necessary, enable storage of values of the proper magnitude by enlarging the data column in question. In the case described above regarding CA Datacom/DB recovering from a bad WHERE clause predicate, the predicate should generally be corrected.
|
Copyright © 2014 CA.
All rights reserved.
|
|