Using Column and Alias Names Teradata

There are considerations when using column and alias names within a stored procedure:

  • Columns in the cursor specification of a FOR statement may be assigned an alias
  • An expression used in the cursor specification must be assigned an alias
  • A column/alias name must be unique in a FOR statement
  • A column/alias name can be the same as the FOR-loop variable and cursor names in a FOR statement
  • A column/alias must be referenced in the body of the FOR iteration statement by qualifying it with the associated FOR-loop variable name
  • Scope of a column/alias of a FOR statement is the body of the statement

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd Protection Status

Teradata Topics