similar to: connection DB2 and R (R under linux)

All- Does anyone on the list have experience with building RODBC from source on a Linux box for use with DB2? I am using (all from source): R 2.0.1 unixODBC 2.2.9 RODBC 1.1-3 For example: [jcole]$ R CMD INSTALL RODBC_1.1-3.tar.gz 2> rodbc.log * Installing *source* package 'RODBC' ... checking for gcc... gcc checking for C compiler default output file name... a.out checking whether

I am running R version 2.9.2 on Windows XP OS with RODBC version Version: 1.3-0. Has anyone out there in the R user community successfully appended records to a DB2 table on a remote database using the sqlSave function in the RODBC package? (or by any other means from R?) I posed a similar question a few months ago and unfortunately, did not receive a response. I was hoping recent upgrades to

I am running R version 2.8.1 on Windows XP OS. This works fine. (Data.frame dta is created with records from the DB2 table.): sql <- "select * from storage.testappend_slt order by uut" dta <- sqlQuery(channel,sql) But when I try to append records (from data.frame newdta) to the same DB2 table. I get an error: sqlSave(channel, newdta, tablename = storage.testappend_slt, append

Hi, i am trying to connect to a DB2 server using the DBI library. getData <- function() { driver <- dbDriver("DB2") conn <- dbConnect(driver,"server","uname","pword") data <- dbSendquery(conn, "select etc.") } When I run the function, i get the error > data <- getData() Error in

On 3/30/2015 11:44 AM, John R Pierce wrote: > On 3/30/2015 8:32 AM, Harold Pritchett wrote: >> Db2 is running our of shared memory. > > open a ticket with IBM DB2 support. > > > IBM db2 Express-C does not include support. You get what you pay for (and db2 Express-C is free) Harold

This will give you something to run on when Oracle refuses to renew the MySQL InnoDB license next year..... Linux and Windows versions You can run DB2 Express-C on up to 2 dual-core CPU servers, with up to 4 GB of memory, any storage system setup and with no restrictions on database size or any other artificial restrictions. Business partners may choose to register for free redistribution of

Db2 is running our of shared memory. The environment: Virtual computers running under VMware ESXi hypervisor version 5.5. Two different virtual machines, each running CentOS 5, db2 express C, and Apache/PHP and vmware tools. The machines each have 8 GB of memory, 4 processors, and a couple of hundred GB of disk space available. Everything is running on the 64 bit versions. The actual

Hello, I have been trying to connect a Rails application to DB2 database. Based on information found on the web it doesn''t seem to be possible. Can some confirm the state of DB2 support with Rails? Thanks for you help, David _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org

I have developed a rails 3 app and for various reasons I have been compelled to try using DB2 as the underlying database system. Does anyone have much experience of using DB2 with rails 3? Any good pointers on resources? I have just been using postgres to date -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on

I often forward IBM DeveloperWorks articles about RoR to this list. This is a new well-written ''Intermediate'' article using DB2 with Rails: http://www.ibm.com/developerworks/db2/library/techarticle/dm-0705chun/ Hope this helps. Cheers Mohit. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups

Anyone has a working installation of DB2 DBI driver for Ruby? Davide

Greetings, I was wondering if anyone on this list has any experience using Ruby/Rails with either DB2 or SQLServer. We''re currently in the later planning stages of two RoR applications and I''m not 100% sure about the state of these two drivers. Googling for this information locates multiple sites that discuss various driver implementations (DBI, etc) for both databases.

I am new user of wine. I have centos 2.6.18-128.el5 x86_64 GNU/Linux and wine-1.0.1. I installed jre for windows in wine and run .bat program that run a java SWT application taht access a database db2. After running for a few moments an error is generated, this error occurs only under wine. DB2 use port 50000. Application.commit Text : [ibm][db2][jcc][t4][2030][11211] A communication

I''m trying to get the Ruby DB2 bindings to compile under Windows XP. I''ve been working on this on and off over the last few days with little success. The second step, "ruby setuyp.rb setup" was generating this error message: ABORT: Could not locate DB2 libraries or headers I know I have Db2 installed correctly so I did a little digging and found that the extconf.rb

Can anyone give advice how to interactively exchange data between R and SQL-Databases like DB2, ORACLE, MS-SQL-Server ? If the answer is: 'currently not', this would be information for me as well. I will summarize to the list. Best regards -- Dr. Jens Oehlschl?gel-Akiyoshi MD FACTORY GmbH Bayerstrasse 21 80335 M?nchen Tel.: 089 545 28-27 Fax.: 089 545 28-10 http://www.mdfactory.de

Hi, I am trying to use sqlSave to write a dataframe to an existing table in a DB2 database. The database contains two schemas. My experience is the following: (1) in the case that tablename is left empty in sqlSave, R writes to the instance level schema (2) in the case that a tablename is specified and that table name exists only once in the database, R will write to that table irrespective

Hi there, Does anyone know when, or if, the DB2 connector will support migrations? Thanks, --Jim

I just saw this mentioned on OSNews: http://www.alphaworks.ibm.com/tech/db2onrails?open&S_TACT=105AGX59&S_CMP=GR&ca=dgr-lnxw07awdb2onrails (or http://tinyurl.com/o9npt) From that page: <quote> What is Starter Toolkit for DB2 on Rails? Users starting with Ruby and Rails are faced with the task of downloading source code, obtaining compilers, compiling code, and finding a

Received this link from a regular email blast, it may interest some of you. I guess RoR is starting to gain more traction :-) http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0606dumbill/?ca=dnw-723 Cheers Mohit.

Hi, I have a data frame with two factors, and I would like to create a new one by "combining" them. I have already a solution, but it is very "heavy", and I'm sure there is a basic function which can do the same. I tried to find it in the R-help, but without result. See the example : # just to create a dataframe f1 <- factor(rep(c("A","B"),3)) f2