Cursors and ANSI Valid-Time Table Queries | Teradata Vantage - 17.10 - Cursors and ANSI Valid-Time Table Queries - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - ANSI Temporal Table Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1186-171K
Language
English (United States)

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