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 |