INFORMIX Query
Hello,
Who can help me convert this SQL statement writtten in Foxpro to a
Informix query. I have problems no being able to use the enhanced
function is Informix.
Regards,
Peter Slendebroek
Mail: slendebroekp.rtn.rabofacet@rabolan.rabobank.nl
SELECT cd.datum, Con_def.commentc,; sum(iif(cd.uur>19 or cd.uur<8,mymax(cd_a.data,cd.data),0)) as
DATA_L,;
sum(iif(cd.uur>19 or cd.uur<8,1,0)) as NR_L,;
sum(iif(cd.uur>19 or cd.uur<8,0,mymax(cd_a.data,cd.data))) as
DATA_H,;
sum(iif(cd.uur>19 or cd.uur<8,0,1)) as NR_H,;
COUNT(cd.datum);
FROM con_data cd , Con_def, con_data cd_a;
WHERE Con_def.con_obj_id = cd.con_obj_id;
AND cd_a.con_obj_id = Con_def.con_obj_id;
AND (cd.l_node_id = Con_def.l_node_id;
AND cd_a.l_node_id = Con_def.r_node_id;
AND cd.datum = cd_a.datum;
AND cd.uur = cd_a.uur;
AND Con_def.commentc = 'EXT:LNV---:');
AND cd.datum >= _bdatum and cd.datum < _edatum;
AND str( Con_def.l_node_id)+str( Con_def.l_slot)+str(
Con_def.l_channel)+str( Con_def.l_dlci) <;
str( Con_def.r_node_id)+str( Con_def.r_slot)+str(
Con_def.r_channel)+str( Con_def.r_dlci);
GROUP BY cd.datum, commentc;
INTO TABLE h:\\kapman\\lnv\\be_data1.dbf
The function mymax in the select statement is as follows:
function mymax
parameter a,b
return max(a,b)