Platform: z/OS; DB2 version: 7.2

The following CASE statement works:
CASE
WHEN A.YEAR = B.YEAR
THEN B.ENTNAME
ELSE ''
END AS ENAME

The following won't work:
CASE
WHEN A.YEAR = B.YEAR
THEN B.ENTNAME
ELSE (select MAX(B.ENTNAME) FROM T1)
END AS ENAME

If I remember right, I thought the embedded SELECT in CASE..ELSE worked on DB2 v7 LUW, Won't the embedded SELECT statement work in DB2 v7 for the mainframe? Let me know please, Thanks - EK

for mainframe that function becomes available in DB2 V8 - compatibility mode

umayer, thank you