error -619 updating Clob using SQL update statement

Technote (troubleshooting)


error -619 updating Clob using SQL update statement


The error -619 is returned when attempting to update Clob data type using a SQL update statement.


Updating CLOB and TEXT data types via SQL statement is Not Allowed.

Resolving the problem

There are a number of limitations when updating data found in a text or clob column which are listed here:

  • You cannot use a quoted text string, number, or any other actual value to insert or update TEXT columns
  • You cannot use TEXT operands in arithmetic or string expressions.
  • You cannot assign literals to TEXT columns in the SET clause of the UPDATE statement.

You also cannot use TEXT values in any of the following ways:
  • With aggregate functions
  • With the IN clause
  • With the MATCHES or LIKE clauses
  • With the GROUP BY clause
  • With the ORDER BY clause

Please see the following discussion in the Infocenter for more details.

TEXT data type

Document information

More support for:

Informix Servers

Software version:

11.5, 11.7, 11.70, 12.1

Operating system(s):

AIX, HP-UX, IRIX, Linux, Platform Independent, Reliant UNIX

Reference #:


Modified date:


Translate my page

Content navigation