Am getting sqlcode -119 (A column or expression identified in a Having clause is not valid) when i execute the below query
SELECT
T1.COL8,
T1.COL9,
COALESCE (( SELECT MAX(CHAR(T2.COL1))
FROM TBL_T2 T2
WHERE T2.COL2 = T1.COL5
AND T2.COL3 = T1.COL6), ' ')
FROM TBL_T1 T1
WHERE
T1.COL1 = 0 AND
T1.COL2 = 'A' AND
T1.COL3 = 147 AND
GROUP BY T1.COL4
T1.COL8,
T1.COL9,
COALESCE (( SELECT MAX(CHAR(T2.COL1))
FROM TBL_T2 T2
WHERE T2.COL2 = T1.COL5
AND T2.COL3 = T1.COL6), ' ')
FROM TBL_T1 T1
WHERE
T1.COL1 = 0 AND
T1.COL2 = 'A' AND
T1.COL3 = 147 AND
GROUP BY T1.COL4
T2.COL1 has been defined as SMALLINT (S9(4) comp). Have used CHAR function because, i don't want it to be displayed as NULL when no row exists. I want ito be displayed as SPACES, hence i am converting into CHAR and Using COALESCE function with spaces as default values.
If i dont have Group By clause, the same query is working fine.
Could you please help me
Thanks
Sikkandhar