On 26 Jun 2003, Steffen Neumann wrote:
> Babu Prathap R <[EMAIL PROTECTED]> 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, [EMAIL PROTECTED]
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
______________________________________________
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help
