CASE Value Expression - Parallel Transporter

Teradata Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-09
dita:mapPath
vyv1488824663502.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

CASE value expressions allow derived column values in a target row to vary depending on which condition is satisfied by the corresponding source row. The CASE value expression has the same structure as the CASE DML expression, except that it associates a numeric value expression or string value expression with each condition rather than a DML group, as follows:

CASE  WHEN <condition 1> THEN <value expression 1>
      WHEN <condition 2> THEN <value expression 2>
        :        :         :            :
      WHEN <condition n> THEN <value expression n>
      ELSE <value expression n+1>
END

The value of a CASE value expression is the value of the expression corresponding to the first condition that is met, else the value of the ELSE’s expression, if present, else NULL. The value expressions must all evaluate to data values of the same basic type, either all numeric or all string.

CASE Value Expression Example

SELECT COL1
       CASE WHEN COL2 < 256    THEN COL4 * 16
            WHEN COL2 > 32767  THEN COL4 + COL5
                               ELSE COL6
       END AS COL2,
       COL3 FROM...