Rules for FOR-Loop Cursor Names - Teradata Vantage - Analytics Database
SQL Stored Procedures and Embedded SQL
- Deployment
- VantageCloud
- VantageCore
- Edition
- VMware
- Enterprise
- IntelliFlex
- Product
- Analytics Database
- Teradata Vantage
- Release Number
- 17.20
- Published
- June 2022
- ft:locale
- en-US
- ft:lastEdition
- 2023-10-30
- dita:mapPath
- frc1628111662093.ditamap
- dita:ditavalPath
- qkf1628213546010.ditaval
- dita:id
- rjx1472253414573
- lifecycle
- latest
- Product Category
- Teradata Vantage™
- A cursor name must be unique if used in the nested FOR iteration statements.
- A cursor name can be the same as the for-loop variable or the correlation or column names in a FOR statement.
- The scope of a cursor name is confined to the FOR statement in which it is defined. If FOR statements are nested, the cursor name associated with an outer FOR statement can be referenced in statements within inner FOR statement(s).