Re: SP's and SQLERRD ???

Jon C. Vemo (jvemo@cyberspace.com) wrote: : Within a SP, I want to perform a select. After the select, I want to : determine whether any rows were found. According to TFM, using dbinfo to get : 'sqlca.sqlerrd2' will return the number of rows processed. Only problem, it : doesn't return anything near accurate results. Just as in 4GL & ESQL/C, "number of rows processed" really applies only to UPDATEs and DELETEs, not to SELECTs. For SELECT's it's pretty much the same as the sqexplain.out "Estimated Rows Returned". I'm afraid that the two options for figuring out number of rows selected are the same two there've always been: FETCH all the rows and count them, or SELECT COUNT(*) June ---- June Tong Informix Software ---- ---- junet@informix.com (415) 926-6140 ----