15.00 - Updatable Cursors and Semantic Database Integrity - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Updatable Cursors and Semantic Database Integrity

Positioned updates using updatable cursors can present semantic integrity problems unless strict locking protocols are observed. Cursor updates (as used here, the word update also includes deletes) must be executed within the same transaction as the SELECT statement that defined the cursor.

Because Preprocessor2 does not support large objects, you cannot use cursors of any kind on columns defined with the XML, BLOB, or CLOB data types.