similar to: connecting to DB2 database

Hello, I seem to have issues with setting the driver: My code: library(RJDBC) getStatic <- function() { # set driver driverClass <- JDBC("com.ibm.db2.jcc.DB2Driver","someClassPath.jar","'") conn <- dbConnect(driverClass,"serverName") etc etc } I get this error > data <-getData()

Hi what does this mean when i get above error? When I call function foo(), specifying parameters a and b as below a<-5 b<-6 > y <- foo(a,b) > Error in foo(a, b) : unused argument(s) (6) Thanks Zava -------------------------------------------------------- This is not an offer (or solicitation of an offer) to bu...{{dropped:24}}

Hi, what is the recommended way to vertically concatenate 2 data frames with the same column names but different number of rows? My problem is something along these lines: df1 <- data.frame(var1=var1,var2=var2,var3=var3) # nrow(df1)=1000 df2 <- data.frame(var1=var4,var2=var5,var3=var6) # nrow(df2)=2000 I tried df <- c(df1,df2), no success. stack does not seem to be appropriate

Hi, is there any function in R that shifts elements of a vector to the opposite direction of what Lag() of the Hmisc package does? (something like, Lag(x, shift = -1) ) Thanks Zava -------------------------------------------------------- This is not an offer (or solicitation of an offer) to buy/se...{{dropped}}

Hi I rbind data frames in a loop in a cumulative way and the performance detriorates very quickly. My code looks like this: for( k in 1:N) { filename <- paste("/tmp/myData_",as.character(k),".txt",sep="") myDataTmp <- read.table(filename,header=TRUE,sep=",") if( k == 1) { myData <- myDataTmp } else{ myData

Dear R-users, I was able to make ROracle package to connect to the DB (Oracle91, 64bit, on Solaris). But after executing siple SQL query, "fetch" commaned gives me an empty dataframe. ### RORACLE INSTALATION PROCEDURE ### R CMD INSTALL --configure-args='--enable-extralibs' --enable-oracle32=no ~/tmp/ROracle_0.5-5.tar.gz #since we have 64bit Oracle9i instalation PROBLEM:

Hi R users, I am a beginner trying to connect to PostgreSQL using R When I give the following command drv<-dbDriver("PostgreSQL") I am getting the following error Error in do.call(as.character(drvName), list(...)) : could not find function "PostgreSQL" I have installed PostgreSQL 8.1 in my system. I am currently using R 2.3.1. Any help would be

Hi, I am just starting to play with R. What is the recommended manner for calculating time spans between 2 dates? In particular, should I be using the "chron" or the "date" package (so far I just found how to calculate a timespan in terms of days)? Thanks Zava -------------------------------------------------------- This is not an offer (or solicitation of an offer) to

Hi, I have a list myList (see below) that consists of id's $'7',....,$'10' and each id has an individual array, the length of which can vary from id to id. How can I convert this list into an array, ie. stacking the individual arrays into one large array? Thanks Zava myList: $`7` [1] 20050201 20050301 20050401 20050501 $`8` [1] 20050201 20050301 20050401

Hi, I would like to generate below triangular matrix for some a. 0 0 0 0 0 0 1 0 0 0 0 0 a 1 0 0 0 0 a^2 a 1 0 0 0 a^3 a^2 a 1 0 0 a^4 a^3 a^2 a 1 0 What's an efficient way to do this? (this matrix being KxK, K very large) Thanks Zava -------------------------------------------------------- This is not an offer (or solicitation of an offer) to buy/se...{{dropped}}

Hi, I have a file fileFoo.R, say that contains these two lines, invoking function foo that is specified in "foo_details.R": source("foo_details.R") foo(parameter1) I want to specify and pass parameter1 in my command line when invoking R in linux: R --no-save <fileFoo.R. How can I do that? And how can I retrieve the value of parameter1 in my fileFoo.R function

Dear List, Java Exception error while reading large data in R from DB using RJDBC. I am trying to read large data from DB table(Vectorwise), using RJDBC connection. I have tested the connection with small size data and was able to fetch DB tables using same connection(conn as in my code). Please suggest where am i going wrong or alternate option to solve such issues while reading large DB

Dear users, I can access an database oracle database using sql developer. This was done by importing an xml file that contains the login details - username, password and specifies that it uses the KERBEROS_AUTHENTICATION. I'm trying to connect R - so that it can access this database - do sql queries and convert the resulting tables into dataframes. I am a novice in SQL and database access

HI. I make this code: getdata<-function('a','b','c' ,'d','e','f'){ drv <- dbDriver("SQLite") con<-dbConnect(drv, "sqlite.db") lt<-dbListTables(con) myf<-data.frame(NULL) for (i in 1:length(lt)) { myfile<-dbReadTable(con,lt[i]) myfile1<-myfile[-c(14:44)] myfile1$MODEL<-gsub(" ",

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

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

Hi all, I would like the following code to work, but it doesn't: library(DBI) library(RODBC) m <- dbDriver("RODBC") # Example for dbConnect(DBI), causes error m <- dbDriver("ODBC") # Example for DBIDriver-class(DBI), causes error The errors are: Error in do.call(as.character(drvName), list(...)) : could not find function "RODBC" (substitute

Hi all! Does anyone know if a vector autoregression package is avaialable that allows binary variables as part of the endogenous system? I'm looking for something along the lines of what is implemented in "Dynamic Forecasts of Qualitative Variables: A Qual VAR Model of US Recessions" by Michael Dueker, 2003, Fed Reserve Bank of St. Louis. Another possibility is the autoregressive

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