[R] RODBC sqlSave does not append the records to a DB2 table
orvaquim at gmail.com
Sun Oct 18 06:49:55 CEST 2009
Before you try from R. Can you tell us what happens when you use
another DB2 client when you try with those credentials?
One thing to note: If you are trying to access DB2 from ODBC on Linux
on DB2 versions before 9.4 there are some particular issues and better
check this http://holmwood.id.au/~lindsay//2007/10/26/setting-up-unixodbc-with-a-remote-db2/
On Sat, Oct 17, 2009 at 1:33 AM, Elaine Jones <jones2 at us.ibm.com> wrote:
> I am running R version 2.9.2 on Windows XP OS with RODBC version Version:
> 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!
> **************** Elaine McGovern Jones ************************
> ISC Tape and DASD Storage Products
> Characterization and Failure Analysis Engineering
> Phone: 408 705-9588 Internal tieline: 587-9588
> jones2 at us.ibm.com
> [[alternative HTML version deleted]]
> R-help at r-project.org mailing list
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
More information about the R-help