[R] Reasons to Use R
Jeffrey J. Hallman
jhallman at frb.gov
Tue Apr 10 14:35:09 CEST 2007
"halldor bjornsson" <halldor.bjornsson at gmail.com> writes:
> Now, R does not have everything we want. One thing missing is a decent
> R-DB2 connection, for windows the excellent RODBC works fine, but ODBC
> support on Linux is a hassle.
A hassle? I use RODBC on Linux to read data from a mainframe DB2 database. I
had to create the file .odbc.ini in my home directory with lines like this:
Driver = DB2
Servername = NameOfOurMainframe
Database = fdrp
UserName = "NachoBizness"
TraceFile = /home/NachoBizness/.odbc.log
and then to connect I do this:
Sys.putenv(DB2INSTANCE = "db2inst")
myConnection <- odbcConnect(dsn = "m1db2p", uid = uid, pwd = pwd, case = "toupper")
with 'uid' and 'pwd' set to my mainframe uid and password.
Now, I am not the sysadmin for our Linux machines, but I don't think they had
to do much beyond the standard rpm installation to get this working.
More information about the R-help