title: Getting top n to n rows from db2
body: <p>I need to split a huge table in to chunks.</p>
  
  <p>Fetching data from DB2 and processing in SSIS</p>
  
  <blockquote>
    <p>iteration 1 : Get first 10 rows and process it </p>
    
    <p>iteration 2 : Get next 10 rows(11-20) and process it </p>
    
    <p>iteration 3 : Get next 10 rows(21-30) and process it</p>
  </blockquote>
  
  <p>and so on till count(*) of a table</p>
  
  <p>Is it possible to get top n to n rows from db2</p>
  
  <p><strong>im looking for a query like below,</strong> </p>
  
  <blockquote>
    <p>select * from from tablename fetch 10 to 20 rows</p>
  </blockquote>