title: Invalid operation result set is closed errorcode 4470 sqlstate null - DB2 data extract
body: <p>I am running a very simple query and trying to extract the results to a text file.  The entire query is essentially what is below, I am selecting everything from one single table with one piece of where criteria which is limiting the data to one month's worth.  After it has extracted around 1.2 gig this error shows up.  Is there any way that I can work around this other than extracting smaller date ranges?  I am trying to pull a couple of years worth of data so if I can only get it a few days at a time it will take a lot of manual work.</p>
  
  <p>I am currently using the free trial of a DB2 query tool - Razor SQL if that makes a difference, I can probably purchase different software if it would help.  I am trying to get IBM's tool but for some reason it freezes during the download so I am still working on that.  I have searched about this error but everything I see seems much more complex than what I am doing and I can't tell if it applies or not.  Thanks in advance.</p>
  
  <pre><code>select *
  from MyTable
  where date_col between date '2014-01-01' and date '2014-01-31'
  </code></pre>