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