-433   VALUE value IS TOO LONG

Explanation

The value value required truncation by a system (built-in) cast or adjustment function, which was called to transform the value in some way. The truncation is not allowed where this value is used. The value being transformed is one of the following:
  • an argument to a user defined function (UDF)
  • an input to the SET clause of an UPDATE statement
  • a value being INSERTed into a table
  • an input to a cast or adjustment function in some other context.

If value has the 'for bit data' subtype, or has a data type of BINARY or VARBINARY, then the value is printed as a hexadecimal string in quotes followed by an X.

System action

The statement cannot be processed.

Programmer response

If value is a literal string in the SQL statement, it is too long for its intended use. If value is not a literal string, examine the SQL statement to determine where the transformation is taking place. Either the input to the transformation is too long, or the target is too short. Correct the problem and rerun the statement.

SQLSTATE

22001