+445 VALUE value HAS BEEN TRUNCATED

Explanation

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.

System action

The value has been truncated.

Programmer response

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

SQLSTATE

01004