| |
- Causa
- O valor não é compatível com o tipo de dado a ser recebido pela tabela.
The data type of the value to be assigned to the column, parameter, host variable or transition variable by the SQL statement is incompatible
with the declared data type of the assignment target.
Both must be:
- Numeric
- Character
- Graphic
- Dates or character
- Times or character
- Timestamps or character
- Row IDs
- The same distinct types
However, dates, times, or timestamps cannot be assigned to a character column that has a field procedure.
Also note that character and graphic data types are compatible when using Unicode.
This SQLCODE is issued for any statement that fails required assignment rule checking.
- Ação do sistema
- O comando não pode ser executado.
- Resposta ao Desenvolvedor
- Examine the current definition for the object table, procedure, user-defined function, or host variable and ensure that the host variable or
literal value that is assigned to the object has the proper data type.
In some cases, you can convert the value to the proper data type by using a function such as CHAR or DECIMAL.
SQLSTATE: 42821
© Copyright IBM Corp.
|
| |
