[R] DB2 ODBC

[Prof Brian Ripley]

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