-134   IMPROPER USE OF A STRING, LOB, OR XML VALUE

Explanation

The SQL statement references a string, LOB, or XML value that is not valid in the context that was specified.

This error can be issued when the length attribute of a string value is too long for the context in which it is used. The string value that you specified is invalid for one of the following reasons:
  • A string value with a length attribute greater than 255 bytes is not allowed in a SELECT list that also specifies DISTINCT.
  • A string value with a length attribute greater than 255 bytes is not allowed for a string representation of a number.
  • A string value with a length attribute greater than 16000 bytes is not allowed for a sort operation such as an ORDER BY clause.
  • A string value with a length attribute greater than 32704 bytes is not allowed as an argument to the REPLACE function.
This error can also be issued when LOB or XML values are specified in a context in which they are not allowed. The LOB or XML value that you specified is invalid for one of the following reasons:
  • A LOB or an XML value is not allowed in an ORDER BY clause.
  • A LOB or an XML value is not allowed in a check constraint.

A token might be returned with the name of the column or special register that resulted in the error. The nature of the error and the syntax in which it occurred determines whether a token is returned.

System action

The statement cannot be processed.

Programmer response

DB2® does not support the requested operation on the string, LOB, or XML value.

SQLSTATE

42907