similar to: Rails using DB2

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

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

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

I''m getting an error 500 and I''m at my wits end as to what could be causing it. I''m sure the path to the ruby executable is correct so what else could be causing it? -- Posted via http://www.ruby-forum.com/.

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

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

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

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

Hi evryone, I would like to access to DB2 on R on a linux machine (R and DB2 are on 2 pc linux ) I have read on the R-archive that RODBC work with DB2, but it is not clear for me, if it's only for R on a windows machine or if it's work also for R under linux ? My data base administrator say that it will not work with linux ? Is it true ? Is there another solution ? Thanks for your help.

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

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, this is a follow up on my previous inquiry regarding the use of the map library (Becker and Wilks 1993). Using the 'world' database I would like to draw filled countries in a world map so that the filling colors of each country corresponds to the value of a policy variable "fix.float" at a specific "year" (the goal is to visualize a policy diffusion pattern

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.

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

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

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.

I have a Date x Stock (223 x 520) matrix of "trading volume". I can calculate a 5-day (past) average in about 1 second using: R> apply(vol, 1, filter, filter=c(0, rep(1/5,5)), sides=1) I would like to do the same with a 5-day median, e.g.: R> mymed <- function(x, n=5) { R> r <- rep(NA, length(x)) R> for (i in (n+1):length(x)) r[i] <- median(x[i-(1:n)]) R>

formatC() is great for formatting numbers! But it would be even better if it could optionally insert commas (or semicolons), e.g. R> formatC(1234567.89, digits=2, format="f", commas=T) [1] "1,234,567.89" Here's a snippet of code that does that, which could more or less just be inserted into at the end of formatC if any R-core guru were so inclined. "r"