Troubleshooting
Problem
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
[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF025","label":"Platform Independent"},{"code":"PF010","label":"HP-UX"},{"code":"PF015","label":"IRIX"},{"code":"PF016","label":"Linux"},{"code":"PF026","label":"Reliant UNIX"}],"Version":"11.5;11.7;11.70;12.1","Edition":"","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21594680