Ansicht
Dokumentation

ABENCDS_SEARCHED_CASE_EXPR_V1 - CDS SEARCHED CASE EXPR V1

- DDIC-Based View, searched_case_expr

... CASE WHEN cds_cond1 THEN result1
        $[WHEN cds_cond2 THEN result2$]
        $[WHEN cds_cond3 THEN result3$]
          ...
        $[ELSE resultn$]
    END ...

Effect

Complex case distinction (searched case) in a SELECT statement of a . The case distinction evaluates the conditions cds_cond1, cds_cond2, ... and returns the operand result as the result after the first THEN for which the condition is true. If none of the conditions are true, the result specified after ELSE is selected. If ELSE is not specified, the result is the zero value. For the operands, general and special rules apply when specifying the conditions. The same applies to result1, result2, ... as for simple case distinction.

Notes

Example

The following CDS view has a complex case distinction in the SELECT list.

The program DEMO_CDS_SEARCHED_CASE uses SELECT to access the view and shows the result.