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

Teradata® Vantage - Database Stored Procedure Compilation (SPL Prefix) Messages

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1096-162K

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.