How to do SQL select top N ... in AS400

Question

How do you perform a

Select top N * from as400table

type query against an as400/db2 database

Answer 1

Select col1,col2
from 
as400table
where col1='filter'
order by col1
fetch first N row only

Answer 2

For future reference:

SQL Reference (V5R4)

Answer 3

owesome, thanks for this