Re: Row Count with Informix 7.2

Tommi M'kitalo wrote: > > Art S. Kagel wrote: > > > Joachim Engel wrote: > > > > > > Hi, > > > > > > is there a possibility to restrict the count of result set rows > > > of a Informix Online Server 7.2 to a certain value? > > > > > > We want to restrict the result set of any Query to max. 100 rows. Not that I am aware of unless you do some clever coding with your front end application. There is the ability to optimize the query for FIRST ROWS. This was achieved with the following SQL statement SET OPTIMIZATION FIRST ROWS; > > > > That is a 7.30 feature. Sorry. > > > > Art S. Kagel > > Hi, > > I've never heard of this feature, but sound interesting. Can you tell > me, how to do that in 7.30? the extended syntax SELECT FIRST 10 * FROM ITEMS will achieve this for you. > > Tommi M'kitalo > Dr. Eckhardt + Partner GmbH