Posted on 2011-04-27
I'm trying to unload some counts using dsntiaul, i think we are on version 8 for db2 and wondering how i can force it to return me the 0 count
so in this query below, i have data for company '02' but not for the status E so I would like it to rertun 0, it's only showing the count for existing '01'
SELECT,CO_ID, SUBSTR(';', 1, 1),
SUBSTR('LAPSED ', 1,11),
WHERE CO_ID IN ('01','02')
AND POL_CSTAT_CD = 'E'
AND POL_STAT_CHNG_DT BETWEEN '2011-04-01' AND '2011-04-27'
GROUP BY CO_ID