[R] DB2 ODBC

Steffen Neumann sneumann at TechFak.Uni-Bielefeld.DE
Thu Jun 26 10:04:04 CEST 2003


Babu Prathap R <prathap_rb at mail.utexas.edu> writes:
[...]
> UDB 8.1 using R. I understand that I need to use R ODBC. But I would like 

What OS ?

On Linux/Solaris you need unixODBC 
(or maybe alternatively iODBC) installed.

Once that works you install RODBC, for unusual 
locations of the sql.h header files,
someone might have to help you to get the compiler flags right.

Once you can load library(RODBC)
you can connection <- odbcConnect("DSN")
and run data <- sqlQuery(connection, "select * from bla")

Yours,
Steffen




More information about the R-help mailing list