Limitations › DQL Mode Limitations › Syntax Limitations › UPDATE/INSERT/ERASE Limitations

UPDATE/INSERT/ERASE Limitations

Following are important limitations to observe when constructing an UPDATE, INSERT, or ERASE query.

• An UPDATE or ERASE query cannot contain a RELATED BY clause.
• Columns that are greater than 240 characters in length cannot be used in a WITH clause or in a SET statement in an INSERT or UPDATE query.