error -619 updating Clob using SQL update statement

Technote (troubleshooting)


Problem(Abstract)

error -619 updating Clob using SQL update statement

Symptom

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


Cause

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
http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.sqlr.doc/ids_sqr_145.htm

Rate this page:

(0 users)Average rating

Document information


More support for:

Informix Servers

Software version:

11.5, 11.7, 11.70, 12.1

Operating system(s):

AIX, Digital Unix (OSF1, Digital Unix (OSF1)(TRU64), HP-UX, IRIX, Linux, Reliant UNIX, Sinix

Reference #:

1594680

Modified date:

2013-04-22

Translate my page

Machine Translation

Content navigation