SPL1105: "%s:E(L%d), Cursor with name %s is not updatable." - Teradata Database

Stored Procedure Compilation (SPL Prefix) Messages

Product
Teradata Database
Release Number
16.10
Language
English (United States)
Last Update
2018-10-22
dita:id
B035-1096-SPL
lifecycle
archive
Product Category
Teradata® Database

SPL1105: "%s:E(L%d), Cursor with name %s is not updatable."

Explanation:

The updatable cursor specification statement has a join condition. Hence, the positioned UPDATE or DELETE statements cannot reference it as an updatable cursor.

Generated By:

TSP module.

For Whom:

End user.

Remedy:

Remove either the join condition or the WHERE CURRENT OF clause from the positioned UPDATE/DELETE statement.