15.10 - Statement Options - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

The SQL procedure body.

You must specify either a single statement or a BEGIN-END compound statement.

You cannot specify any of the following as a single statement in an SQL procedure body:

  • Local variable, cursor, or handler declarations
  • Cursor statements

The following SQL statement sets can be specified as the SQL procedure body.

You can also specify any of the statements in these categories in a statement_list within compound statements, condition statements (CASE and IF), iteration statements, and in the handler action part of a condition handler declaration.