Skip to content
Back to formatted view

Raw Message

Message-ID: <s5uy8zpjmdp.fsf@liszt.TechFak.Uni-Bielefeld.DE>
Date: 2003-06-26T08:04:04Z
From: Neumann, Steffen
Subject: DB2 ODBC
In-Reply-To: Babu Prathap R's message of "Wed, 25 Jun 2003 16:29:39 -0500"

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