[R] How to call stored procedure from RODBC?

[chr.schulz@email.de]

(1) Set a new entry in your system-dsn for your odbc data source.

library(RODBC)
channel <- odbcConnect("dsn_name","","")
sqlFetch(channel, "table_name", errors = TRUE, as.is = FALSE, as = "data frame",
         colnames = FALSE, rownames = FALSE, nullstring = "NA", na.strings = "NA")

....perhaps there are more appropriate functions for you ?
Try
help(RODBC)

regards,Christian

Lingyun Shi schrieb:

Hi,

Does anyone know how to call stored procedure from RODBC? Thanks.

Lingyun

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._




-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._