title: RODBC connection- limited rows
body: <p>I set up an ODBC connect to a Netezza (SQL database). The connection is fine. However, R only pulls out 256 rows by default and restricts the number of rows it can pull out. </p>
  
  <p>If I ran the query in Netezza, it would return a total number of rows (300k). I am expecting the same number of rows in R. However, it only returned 256 rows quite a bit short from 300k.</p>
  
  <p>The driver I am using NetezzaSQL version 7.00.02 NSQLODBC.DLL </p>
  
  <p>I tried to change the pre-fetch count to zero in the "Drivers Option' from
  Control Panel > Administrative Tools > Data Sources(OBBC) > System DNS</p>
  
  <p>It didn't work. Any ideas?</p>