help with syntax for using if inside sum

jagjit · New User Joined: 28 Dec 2006 Posts: 4 Location: india

SELECT SUM (IF CASE_PASTDUE > 0
SET CASE_PASTDUE TO CASE_PASTDUE
ELSE SET 0 TO CASE_PASTDUE)
FROM DB2TEST.SPLIT_DETAIL
WHERE SPLIT_TRANS_ID = 10
AND SPLIT_LEVEL = 22;

muthuvel

I am not clear of your requirement but seeing the sql why can't the CASE_PASTDUE be used with the WHERE clause?

Anyway for SUM syntax is,
Select SUM (column name) AS < variable>
from <table name>
Where <condition>

Craq Giegerich