DB2的SQL Select command中使用CASE WHEN... THEN (IF...Then....Else)

範例：

SELECT
 (
    CASE WHEN (field1 = 'A') THEN 'ADD' 
         WHEN (field1 = 'D') THEN 'DEL'
    ELSE 'Error' 
    END
 ) AS codeName 
FROM codeMapping