Cursors and ANSI Valid-Time Table Queries | Teradata Vantage - 17.00 - Cursors and ANSI Valid-Time Table Queries - Teradata Database

Teradata Vantage™ - ANSI Temporal Table Support

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-1186-170K

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 Teradata Vantage™ - Temporal Table Support , B035-1182 .

Related Information

For more information on... See...
cursors Teradata Vantage™ - SQL Stored Procedures and Embedded SQL , B035-1148