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

[Orvalho Augusto]

Hello!

Before you try from R. Can you tell us what happens when you use
another DB2 client when you try with those credentials?

One thing to note: If you are trying to access DB2 from ODBC on Linux
on DB2 versions before 9.4 there are some particular issues and better
check this http://holmwood.id.au/~lindsay//2007/10/26/setting-up-unixodbc-with-a-remote-db2/

Caveman


On Sat, Oct 17, 2009 at 1:33 AM, Elaine Jones <jones2 at us.ibm.com> wrote:
>
>
> I am running R version 2.9.2 on  Windows XP OS with RODBC version Version:
> 1.3-0.
>
> Has anyone out there in the R user community successfully appended records
> to a DB2 table on a remote database using the sqlSave function in the RODBC
> package? (or by any other means from R?)
>
> I posed a similar question a few months ago and unfortunately, did not
> receive a response.  I was hoping recent upgrades to our DB2 on the
> database, and I installed the current version RODBC. Unfortunately, it did
> not bring any joy. I asked the database adminstrator try it, and she had a
> similar experience.  No error message is returned, but the record is not
> inserted to the table.
>
> For testing purposes, I have a very simple one-row, three-column
> data.frame (se2) I want to insert into a DB2 table.
>
>> sqlSave(channel, se2, tablename = "STORAGE.TEST_APPEND2", append = TRUE,
> +         rownames = FALSE, colnames = FALSE,
> +         verbose = TRUE,
> +         safer = TRUE, addPK = FALSE,
> +   fast = FALSE, test = FALSE, nastring = NULL)
>
> Query: INSERT INTO STORAGE.TEST_APPEND2 ( "MACRONAME", "MACROUSER",
> "MACRO_RT" ) VALUES ( 's_ej_mach_config_vz', 'jones2', 5 )
>>
>
> I don't get any error message, but when I check the table row count, the
> record has not been added to the table.
>
> Any suggestions for how to resolve are appreciated!
> 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.
>