Well I do not know what could be happening. I tried to append records to a table on DB2 (community Edition 9.5 on a Linux machine). And it works greatly. The only odd thing (may be because of my low skills on DB2) is I could not create neither append to a table on a different schema than dbuser (actually my account was dbuser).
My R version is 2.7.1 under another Linux PC and RODBC is 1.2-3. Caveman On Tue, Oct 20, 2009 at 8:45 PM, Elaine Jones <jon...@us.ibm.com> wrote: > The query generated by R looks ok to me. I went ahead and pasted it into my > DB2 Client command editor. And I got the message confirmation message. > > INSERT INTO STORAGE.TEST_APPEND2 ( "MACRONAME", "MACROUSER", "MACRO_RT" ) > VALUES ( 's_ej_mach_config_vz', 'jones2', 5 ) > > DB20000I The SQL command completed successfully. > > And I confirmed the record was added to the table. > > **************** 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 > > > > > ______________________________________________ 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.