HPE NonStop SQL/MX Error – 4198 Clustering key columns cannot be specified in the SET clause of an embedded UPDATE statement.

Data 22 Views 1 Min Read

In this blog post, let’s learn about the error message “4198 Clustering key columns cannot be specified in the SET clause of an embedded UPDATE statement.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4198 Clustering key columns cannot be specified in the SET clause of an embedded UPDATE statement.

Reason for the Error

You specified the clustering key columns in the SET clause of an embedded UPDATE statement.

Solution

Remove the clustering key columns from the SET clause and recompile the statement

Tags: