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.
