Limit # of rows returned in SQL

[Sparc]

I'm trying to code an SQLRPGLE program to return a set # of rows from a file but have so far been unsuccessful. Anyone know of a keyword or formula that i may have overlooked?

All i want to do is return the first 25 records from a file containing 400 records. Should i try to key off of the relative record number in the file?

 

[iSeriesCodePoet]

I think it is the keyword ROWS, but I am not positive. I would look it up on the online DB2 books on IBM's web site. Mike Wills
AS400 Programmer

 

[Guest_imported]

try using FETCH FIRST n ROWS ONLY where n is an integer corresponding to the number of rows you want.

 

[tman24m]

SQL permits use of something like

SELECT TOP 25 * FROM
or
SELECT TOP 25 PERCENT * FROM