SQL problem

Hello All, I'm using informix-esql/c. problem : I want to know the number of rows a select statement returns. 'source' : EXEC SQL prepare exec from "SELECT FROM WHERE "; EXEC SQL declare curs for exec; EXEC SQL open curs; for { EXEC SQL fetch curs into ... } I use sqlca.sqlerrd[2] to get the number of rows. This value is properly filled after all the rows are fetched. Is it possible to get the number of rows before all the fetch's? I'd tried fetch last followed by fetch next but that doesn`t work. Any suggestions ? Thanks in advance for the responce, Siebe de Klaver s.w.deklaver@interedge.nl