Rules for FOR Cursors - Advanced SQL Engine - Teradata Database

SQL Stored Procedures and Embedded SQL

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
vqj1592443206677.ditamap
dita:ditavalPath
vqj1592443206677.ditaval
dita:id
B035-1148
lifecycle
previous
Product Category
Teradata Vantageā„¢
  • ABORT, COMMIT, and ROLLBACK statements are not permitted in an updatable cursor.

    An attempt to execute any of these statements returns a runtime error.

  • The cursor specification must not return the warning code 3999.
  • The cursor specification cannot contain a WITH ... BY clause.
  • If the cursor specification contains a UNION operator, the referenced correlation or column name must be the correlation or column names used in the first SQL SELECT statement.