Previous Topic: -173 - THE REFERENCING AND REFERENCED COLUMNS ARE NOT EQUIVALENTNext Topic: -175 - FOREIGN KEY <authid.constraintname> REFERENCE VIOLATION


-174 - UPDATE/DELETE CANNOT HAVE CORRELATED SUBQRY

Explanation

An INSERT or DELETE statement included a correlated subquery, but the inclusion of a correlated subquery (a subquery that references a column value from an outer query) is not supported.

The SQLSTATE that equates to this SQL return code is 42902.

User Response

Consider using a positioned UPDATE or positioned DELETE statement instead.