15.10 - Statement Options - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Teradata Database
Release Number
December 2015
Content Type
Programming Reference
Publication ID
English (United States)

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.