15.10 - Cursors and ANSI Valid-Time Table Queries - Teradata Database

Teradata Database ANSI Temporal Table Support

prodname
Teradata Database
vrm_release
15.00
15.10
category
Programming Reference
featnum
B035-1186-015K

A cursor is a data structure that stored procedures and Preprocessor2 use at runtime to point to the result rows in a response set returned by an SQL query. Procedures and embedded SQL also use cursors to manage inserts, updates, execution of multistatement requests, and SQL macros.

Cursors are not supported with ANSI valid-time tables, however they are supported on valid-time tables that use the CURRENT qualifier of Teradata non-ANSI temporal syntax. For information on using DML with cursors on valid-time tables, see Temporal Table Support.