SQL Codes › SQL Return Codes -1 through -999 › -130 - CURSOR NOT UPDATEABLE

-130 - CURSOR NOT UPDATEABLE

Reason:

The FOR UPDATE OF clause was specified in the SQL select-statement, which can be used in the DECLARE CURSOR statement.

A cursor is not updateable, that is, it is read-only, if there are any of the following:

• More than one table in the FROM clause.
• A GROUP BY clause or all column functions in the SELECT list.
• An ORDER BY clause.
• The keyword DISTINCT.
• A UNION operator.
• A FOR FETCH ONLY clause.
• The table being updated also being referenced in a subquery.
• A plan isolation level of "U" (no locking).

See the Declare Cursor section and the select-statement in the CA Datacom/DB SQL User Guide for more information.

The SQLSTATE that equates to this SQL return code is 24S05.

Action:

Either make the cursor updatable or remove the FOR UPDATE OF clause from the select-statement.