Use Case in DB2

Use Case in DB2

1. CaseA FieldWhenA ValueThenAssign a valueElseAssign another valueEnd

2. Or: CaseA FieldWhenA ValueThenAssign another valueEnd

3. Note:

1. Then and else do not have to be used together
2. You can even execute SQL statements after when or after Else.Code.

Example:

-- 1

Select * From sy_corp_product
Where
Case n_corp_code when 969 then 123 else n_corp_code end = 969
;

-- 2

Select * From sy_corp_product where n_corp_code = 123;

-- 3

Select * From sy_corp_product where n_corp_code = 969;

1 dataset = 2 dataset of U3

--> inline decoration begins here.
--> identified directly by the context.
-->