How do you do LIMIT in DB2 for iSeries? 
I have a table with more than 50,000 records and I want to return records 0 to 10,000, and records 10,000 to 20,000.
I know in SQL you write  LIMIT 0,10000 at the end of the query for 0 to 10,000 and LIMIT 10000,10000 at the end of the query for 10000 to 20,000 
So, how is this done in DB2? Whats the code and syntax? (full query example is appreciated)
 
     
     
     
     
     
     
     
     
     
    