Ansicht
Dokumentation

SQL0406 - Conversion error on assignment to column &2. ( OS/400 )

ABAP Short Reference   ABAP Short Reference  
This documentation is copyright by IBM.


Message : SQL0406
Conversion error on assignment to column &2.

Message Long Text :

Cause . . . . . : During an attempt to assign a value to column &2 with an INSERT, UPDATE, ALTER TABLE, or REFRESH TABLE statement, conversion error type &3 occurred. If precompiling, the error occurred when converting a numeric constant to the same attributes as column &2. A list of the error types follows:
-- Error type 1 is overflow.
-- Error type 2 is floating point overflow.
-- Error type 3 is floating point underflow.
-- Error type 4 is a floating point conversion error.
-- Error type 5 is not an exact result.
-- Error type 6 is numeric data that is not valid.
-- Error type 7 is DBCS data that is not valid.
Recovery . . . : Change the statement so that the result value fits in column &2 and is valid, or create the table or view again, specifying a new type or length for column &2 so that the result value can be assigned.
Technical description . . . . . . . . : During precompile, an attempt is made to convert numeric constants in INSERT and UPDATE statements to the attributes of the target column. This would improve performance when the program is called.

Message File : QSQLMSG
Library Message File : QSYS2924


TXBHW - Original Tax Base Amount in Local Currency   ABAP Short Reference  
This documentation is copyright by IBM.

Length: 3242 Date: 20240419 Time: 151746     sap01-206 ( 3 ms )