similar to: RODBC sqlSave with DB2

essai <- odbcConnect("ORESTE_prod", uid="osis_r", pwd="12miss15" ,case="oracle") > sqlTables(essai)$ORESTE ... 1315 <NA> ORESTE S_PROFESSIONS_OLD TABLE <NA> 1316 <NA> ORESTE S_PROVENANCES TABLE <NA> 1317 <NA> ORESTE

What is this error message about and how do I troubleshoot it? > sqlTables(channel) Error in .Call("RODBCFetchRows", attr(channel, "handle_ptr"), max, buffsize, : negative length vectors are not allowed The channel was created as such channel <- odbcConnect("Labdata") I think this is telling me that my odbcConnect command worked >

Hello, We are having some strange issues with RODBC related to integer columns. Whenever we do a sql query the data in a integer column is 150 actual data points then 150 0's then 150 actual data points then 150 0's. However, our database actually has numbers where the 0's are filled in. Furthermore, other datatypes do not have this problem: double and varchar are correct and do not

Hi. I attempted to use RODBC and decided to execute all the tests provided in "Test.r" under the unpacked package RODBC folder. Beginning with the following: library(RODBC) library(MASS) USArrests[1,2] <- NA hills <- hills[1:15,] row.names(hills)[12] <- "Dollar ('$')" set.seed(1) # MySQL ## testdb3 is ODBC/Connector 3.51.x, testdb5 is 5.1.x channel <-

I am running R version 2.8.1 on Windows XP OS. recs is a one-row, eighteen-column data.frame I want to insert into a DB2 table. sqlSave(channel, recs, tablename = "testappend_slt", append = TRUE, + rownames = FALSE, colnames = FALSE, + verbose = TRUE, oldstyle = FALSE, + safer = TRUE, addPK = FALSE, + fast = FALSE, test = FALSE, nastring = NULL) Query:

Hello, Does anyone know a way to connect from R on Linux box to TeraData server? I can use ODBC connection on Windows box, but with amount of data I need (and prefer) to use large Linux box. Thanks, Vadim

I have an MS Access database with one table and one column holding rep(1:10) I use: library(RODBC) channel <- odbcConnect("test") sqlQuery(channel, paste("SELECT col FROM tblTest"), believeNRows=FALSE) and get: 49 50 51 52 53 54 55 56 57 12337 What? The above should, of course, read: 1 2 3 4 5 6 7 8 9 10 I tried the 'odbcQuery' /

I'm trying to create a function which will allow me to subset a data set based on values of various specified variables. I also want to then apply some other function(s) (e.g., summary). This is what I've tried so far.... > test.fx <- function(dta, expvar, expval) { + newdta <- subset(dta, eval(expvar)>expval) + summary(newdta$eval(expvar)) + } > >

I am getting segfaults when I try to read a large binary object from a SQL Server database via RODBC. I am using the FreeTDS ODBC driver, and it has been working fine when reading from this same database. I have included relevant parts of the session below. Each row of the v_MAFiles view holds a text, html or pdf version of a document. The FileType entry is one of TXT, PDF, or HTML. If

Was wondering when this would be suggested. But the question was about getting the final dataframe... newdta <- olddta newdta$FirstDay <- ave(newdata$date, newdata$ID, FUN = \(x) x[1L]) On November 27, 2024 11:13:49 AM PST, Rui Barradas <ruipbarradas at sapo.pt> wrote: >?s 16:30 de 27/11/2024, Sorkin, John escreveu: >> I am an old, long time SAS programmer. I need to

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

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

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

?s 16:30 de 27/11/2024, Sorkin, John escreveu: > I am an old, long time SAS programmer. I need to produce R code that processes a dataframe in a manner that is equivalent to that produced by using a by statement in SAS and an if first.day statement and a retain statement: > > I want to take data (olddata) that looks like this > ID Day > 1 1 > 1 1 > 1 2 > 1 2 > 1 3 >

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

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

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.

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

I''ve made a research patch [1] for Active Record which creates a new interface for working with limit and offset parameters, and it needs implementations for the commercial databases. The patch is described in detail in trac ticket #795 [2]. I''d greatly appreciate any contributions you can make as soon as possible so that this fix can make it in to the Rails 1.0 release.