[R] RODBC sqlQuery question

Sean Davis sdavis2 at mail.nih.gov
Tue Jan 17 14:31:30 CET 2006


Why does this happen when I do a sqlQuery?

> sessionInfo()
Version 2.3.0 Under development (unstable) (2006-01-04 r36984)
powerpc-apple-darwin8.3.0

attached base packages:
[1] "methods"   "stats"     "graphics"  "grDevices" "utils"     "datasets"
[7] "base"     

other attached packages:
  RODBC 
"1.1-5" 
> b <- sqlQuery(con,"select * from HartProbe where PROBE_ID='Hart19'")
SQLNumResultCols
SQLNumResultCols
SQLDescribeColW
SQLDescribeColW
SQLDescribeColW
SQLDescribeColW
SQLFetch
SQLFetch

I get output for each row returned.  In this case, the table has a million
rows, so I can't really select from it reasonably.  It doesn't look to me
like sqlQuery or sqlGetResults has a verbose option to turn off such output.

Thanks,
Sean




More information about the R-help mailing list