Now it becomes strange. One thing I note from this generated query: INSERT INTO STORAGE.TEST_APPEND2 ( "MACRONAME", "MACROUSER", "MACRO_RT" ) VALUES ( 's_ej_mach_config_vz', 'jones2', 5 )
The names of the variables are in double quotes; That is a problem. Can you try to run this query on another application and see what you get. Caveman On Tue, Oct 20, 2009 at 7:05 PM, Elaine Jones <jon...@us.ibm.com> wrote: > Hi Felipe, > Thanks for your message. Your approach works for an Access database. I am > trying to insert records into a table in a DB2 database on a remote AIX > server. > My userid has the authority to insert records, and I am able to do that > using another application (DB2 Client command line). > 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.