Nested case

[rumana shaik]

Is nested case allowed in DB2?

If so can u please tell me the syntax for that?

[naval123]

Is nested case allowed in DB2?

If so can u please tell me the syntax for that?

yes it is allowed.....
i am sending u a update statement with nested case.

UPDATE STAFF
SET COMM = CASE DEPT
WHEN 15 THEN COMM * 1.1
WHEN 20 THEN COMM * 1.2
WHEN 38 THEN
CASE
WHEN YEARS < 5 THEN COMM * 1.3
WHEN YEARS >= 5 THEN COMM * 1.4
ELSE NULL
END
ELSE COMM
END
WHERE COMM IS NOT NULL
AND DEPT < 50;