Keyword introducing a local variable declaration, cursor declaration, or condition handler declaration statement.
DECLARE is followed by a list of local variables, a cursor specification, or a list of handler declarations.
You can specify multiple local variable declarations, cursor declarations, or condition handler declarations for each procedure.
See Teradata Vantage™ SQL Stored Procedures and Embedded SQL , B035-1148 for details.