Previous Topic: -76 - colName IN HAVING NOT GROUP COLUMN OR COLUMN FUNCTION ARGUMENTNext Topic: -80 - ONLY ONE DISTINCT CLAUSE ALLOWED PER QUERY


-79 - UPDATE/DELETE WHERE CURRENT OF cursorname ON READ ONLY CURSOR

Reason:

The DECLARE CURSOR used DISTINCT, GROUP BY, ORDER BY, or UNION clause.

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

Action:

Remove the offending clause to execute the desired function.