R help - Jun 2003 - DB2 ODBC

Hi,

I need to do some statistical analysis of data that is stored in IBM DB2 
UDB 8.1 using R. I understand that I need to use R ODBC. But I would like 
to know more about how to go about this. I apprecaite your help.

Thanks
Babu

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