[R] RODBC sqlSave does not append the records to a DB2 table

Orvalho Augusto orvaquim at gmail.com
Tue Oct 20 19:58:29 CEST 2009

Now it becomes strange.

One thing I note from this generated query:
"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


On Tue, Oct 20, 2009 at 7:05 PM, Elaine Jones <jones2 at 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
>       jones2 at us.ibm.com
>        [[alternative HTML version deleted]]
> ______________________________________________
> R-help at 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.

More information about the R-help mailing list