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
DB2 ODBC
3 messages · Babu Prathap R, Neumann, Steffen, Brian Ripley
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
On 26 Jun 2003, Steffen Neumann wrote:
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")
All of which is in the RODBC package's README, of course, and the last para even in the R Data Import/Export Manual. I think the issue is finding an ODBC driver for DB2. That seems only available for Windows and perhaps Linux on certain IBM boxes.
Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595