Cierto, me equivoque: Se puede limitar si usas V5R1 o superior:
SELECT * FROM TABLA FETCH FIRST 10 ROWS ----- Original Message ----- From: "Informatica" <[EMAIL PROTECTED]> To: "Forum.Help400" <[EMAIL PROTECTED]> Sent: Friday, June 06, 2003 9:09 AM Subject: Re: Limitar resultados de un Select > > ----- Original Message ----- > From: "alex martinez" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, June 05, 2003 6:23 PM > Subject: Re: Limitar resultados de un Select > > > > SELECT * FROM TABLITA OPTIMIZE FOR 10 ROWS > > > > Pues no se, parece que no funciona. Por lo que he leido, en el manual, esta > clausula le dice al GBBDD que se pretenden aprovechar del resultado solo las > 10 primeras filas, pero no "truncando" el resultado. Parece mas bien un tema > de rendimiento. �hay que controlar luego el resultado por programa? > > > Del manual de SQL: > > OPTIMIZE integer ROWS > > The optimize-clause tells the database manager to assume that the program > does > not intend to retrieve more than integer rows from the result table. Without > this > clause, or with the keyword ALL, the database manager assumes that all rows > of > the result table are to be retrieved, and it optimizes accordingly. > Optimizing for > integer rows, or at a minimum, the number of rows that are fetched, could > improve > performance. The clause does not change the result table or the order in > which the > rows are fetched. Any number of rows can be fetched, but performance can > possibly degrade after integer fetches. The clause can appear either before > or after > an accompanying update-clause or read-only-clause. > optimize-clause > > > _____________________________________________________ > Forum.HELP400 es un servicio m�s de NEWS/400. > � Publicaciones Help400, S.L. - Todos los derechos reservados > http://www.help400.es > _____________________________________________________ > > Para darte de baja, env�a el mensaje resultante de pulsar > mailto:[EMAIL PROTECTED] > _____________________________________________________ Forum.HELP400 es un servicio m�s de NEWS/400. � Publicaciones Help400, S.L. - Todos los derechos reservados http://www.help400.es _____________________________________________________ Para darte de baja, env�a el mensaje resultante de pulsar mailto:[EMAIL PROTECTED]
