[R] R 2 UDB

[Prof Brian Ripley]

On Tue, 20 Nov 2007, Duncan Murdoch wrote:

> On 11/20/2007 12:56 PM, Michael Grishin wrote:
>> I am running R on the linux platform.  Is there any way to connect to
>> UDB(DB2) dbms?  How?
>
> I don't know that dbms at all, but if it supports ODBC, then the RODBC
> package should be able to talk to it.

Yes, see http://www.unixodbc.org/, click on Drivers and what looks like 
that is mentioned.

See also 
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0401chong/index.html

The other possibility is to use JDBC: see package RJDBC.  I've had a lot 
less success with this route: maybe it works on i386 Linux better than on 
x86_64 Linux.

-- 
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