16.20 - FOR - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

Keyword introducing an iteration statement to repeat the execution of one or more statements for each row fetched by the cursor.

for_loop_variable
Name of the FOR loop.
See Teradata Vantage™ SQL Fundamentals, B035-1141 for the rules for naming database objects.
cursor_name
Name of the cursor.
The maximum length of a database object name is either 30 LATIN characters or 128 Unicode characters. For details about object name length limits, see Teradata Vantage™ SQL Fundamentals, B035-1141.
CURSOR FOR
Optional keywords qualifying the cursor_name as the cursor for the statement set to follow.
cursor_specification
The SELECT statement specifying the column names or expressions from which to fetch data rows in the CURSOR statement.
DO
Keyword introducing the sequence of statements to be performed in the CURSOR statement.
END FOR
Keywords ending the CURSOR statement.