Usage Notes (All Forms) - 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ā„¢
  • Each cursor declaration must specify a different cursor name.
  • A cursor name cannot exceed 18 characters.
  • The cursor declaration for a particular cursor name must precede any references to that cursor name in other embedded SQL or stored procedure statements.
  • In COBOL, you can specify the DECLARE CURSOR statement either in the DATA DIVISION or in the PROCEDURE DIVISION.