15.00 - 9376 The temporal request violates cursor semantics. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

9376 The temporal request violates cursor semantics.

Explanation:

Two cases may cause the error: 1. A table is opened by a current updatable cursor and a non-current searched update is performed on the table before the cursor does update. Then when the cursor does update later, confliction happens. 2. The temporal qualifier of a searched update/delete on a table, which is currently being updated by a updatable cursor, is not current.

Generated By:

OPT modules

For Whom:

End user

Remedy:

Change the temporal qualifier of the updatabale cursor's SELECT/UPDATE/DELETE statement to CURRENT.