How do you perform a
Select top N * from as400table
type query against an as400/db2 database
order by col1
fetch first N row only
Remember to set an
ORDER BY clause, because DB2 does not guarantee that the rows returned by
FETCH FIRST N ROW ONLY are always the same N.