Re: Mapping of "Ser Rowcount" In Informix

may be: select first 100 somecol1, somecol2, somecol3,...... from sometable will fetch 100 rows (if there are 100...) what tool are you using?? when fetch you can always keep track of how many rows are fetched... if your number is reached then close the cursor.... etc. Superboer. Kuldeep schreef: > How to restrict no. of records in Informix. > means i wana a procdure wich will no. of records returned by select > statement. > This can be be done by cursor. But How? I am confused > like "set rowcount" in Sql Server