CASE Syntax Elements - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
operand_1
operand_2
Value expressions or arithmetic and string expressions.
You can specify stored procedure local variables, status variables, IN or INOUT parameters, literals, and FOR loop column and correlation names in the value expression.
OUT parameters and subqueries are not allowed.
The data type of operand_1 and operand_2 must be compatible.
statement
Any of the following:
  • DML, DDL or DCL statement that can be used in a stored procedure. These include dynamic SQL statements.
  • Control statements, including BEGIN END.
conditional_expression
A boolean condition that determines whether to run the statement or statements in the THEN clause.
You can specify stored procedure local variables, status variables, IN or INOUT parameters, literals, and FOR loop column and correlation names in the conditional_expression.
OUT parameters and subqueries are not allowed.
You cannot use IN and NOT IN operators if the conditional list contains any local variables, parameters, or cursor aliases.