I'm using DB2 with perl and I make this select in my code:
$sth= $dbh->prepare ("select
date(wedthreenregis),wenid_app,wealias,count(weduration) from
slegault.weexectime where date(wedthreenregis)= ? and wenid_app= ? group by
date(wedthreenregis),wenid_app,wealias");when the count(weduration) is 0 nothing print to the screen. I need that because I put the result in a array and make a graph from this array, so I need always the same format in the result of the query. Someone can help me?
