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.
- A SELECT statement on a temporal table can open an updatable cursor if the statement conforms to all existing rules on updatable cursors.
- A SELECT or DELETE statement that opens an updatable cursor has the same syntax as described in Teradata Vantage™ - SQL Data Manipulation Language, B035-1146, but for system-versioned system-time tables the FROM clause cannot t include the special ANSI temporal FOR SYSTEM TIME clause.
|For more information on...||See...|
|cursors||Teradata Vantage™ - SQL Stored Procedures and Embedded SQL , B035-1148|