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

[Orvalho Augusto]

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