Aviso importante
Caso tenhas alguma
dúvida a respeito
da linguagem mande
um e-mail que terás
a resposta.
  C. A. Dornelles

SQL - SQLCODE's - Códigos positivos


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF.

SQLCode +445
VALUE value HAS BEEN TRUNCATED

Causa
The value value was truncated by a cast function, which was called to transform the value in some way. This is a warning situation. The cast function is a result of
  • a CAST specification
  • a built-in function such as CHAR, VARCHAR, etc.
  • a CAST FROM specification on the CREATE FUNCTION statement that created the function
  • a user-defined function that is sourced on another function and the result needed to be transformed.
If 'value' has the 'for bit data' subtype, then the 'value' is printed as a hexadecimal string in quotes followed by an X.

Ação do sistema
The value has been truncated.

Resposta ao Desenvolvedor
Ensure that the output is as expected and that the truncation has not caused any unexpected consequences.

SQLSTATE: 01004