Elaine: Try this. It works for me using my own database. Perhaps you don't have admin rights. Good luck
library(RODBC) myDB <- odbcConnectAccess("DB2.mdb",uid="admin",pwd="") sqlSave(myDB,se2,rownames=FALSE,append=TRUE) close(myDB) Felipe D. Carrillo Supervisory Fishery Biologist Department of the Interior US Fish & Wildlife Service California, USA --- On Fri, 10/16/09, Elaine Jones <jon...@us.ibm.com> wrote: > From: Elaine Jones <jon...@us.ibm.com> > Subject: [R] RODBC sqlSave does not append the records to a DB2 table > To: r-help@r-project.org > Date: Friday, October 16, 2009, 4:33 PM > > > 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 > our DB2 on the > database, and I installed the current version RODBC. > Unfortunately, it did > not bring any joy. I asked the database adminstrator try > it, and she had a > similar experience. No error message is returned, but > the record is not > inserted to the table. > > For testing purposes, I have a very simple one-row, > three-column > data.frame (se2) I want to insert into a DB2 table. > > > sqlSave(channel, se2, tablename = > "STORAGE.TEST_APPEND2", append = TRUE, > + rownames = FALSE, > colnames = FALSE, > + verbose = TRUE, > + safer = TRUE, addPK > = FALSE, > + fast = FALSE, test = FALSE, nastring = > NULL) > > Query: INSERT INTO STORAGE.TEST_APPEND2 ( "MACRONAME", > "MACROUSER", > "MACRO_RT" ) VALUES ( 's_ej_mach_config_vz', 'jones2', 5 ) > > > > I don't get any error message, but when I check the table > row count, the > record has not been added to the table. > > Any suggestions for how to resolve are appreciated! > Sincerely, > > **************** Elaine McGovern Jones > ************************ > > ISC Tape and DASD Storage Products > Characterization and Failure > Analysis Engineering > Phone: 408 > 705-9588 Internal tieline: 587-9588 > jon...@us.ibm.com > > > > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@r-project.org > mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, > reproducible code. > ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.