RODBC sqlSave with DB2

I am running R version 2.8.1 on  Windows XP OS.

This works fine. (Data.frame dta is created with records from the DB2
table.):

sql <- "select * from storage.testappend_slt order by uut"
dta <- sqlQuery(channel,sql)

But when I try to append records (from data.frame newdta) to the same DB2
table. I get an error:

sqlSave(channel, newdta, tablename = storage.testappend_slt, append = TRUE,
+         rownames = FALSE, colnames = FALSE,
+         verbose = FALSE, oldstyle = FALSE,,
+         safer = TRUE, addPK = FALSE, typeInfo, varTypes,
+         fast = TRUE, test = FALSE, nastring = NULL)

Error in sqlSave(channel, dta, tablename = storage.testappend_slt, append =
TRUE,  :
 object 'storage.testappend_slt' not found

I've tried variations on the table name including dropping the schema,
using all uppercase, adding the tablespace name, etc., all without success.
Maybe you did not try giving the name as a character string (in 
quotes)?  For the help:

tablename: character: a database table name accessible from the
           connected dsn.  If missing, the name of 'dat'.

You gave the name of a non-existent R object and got an R error 
message.
I searched R help and found similar problems have been encountered with
Oracle and postgresSQL.
No, other probems what you may get when you want to use a schema: 
maybe try to get what you want to do to work without one first?
     http://www.mail-archive.com/r-help at r-project.org/msg19386.html

The approach in the above link looked promising, but I don't know how to
set the search path for DB2...
Which is not an R question, and surely you someone posting from 
ibm.com can get help on an IBM product elsewhere.
Additional information, possibly helpful?

odbcGetInfo(channel),
      DBMS_Name              DBMS_Ver    Driver_ODBC_Ver
Data_Source_Name        Driver_Name       Driver_Ver         ODBC_Ver
    "DB2/AIX64"         "08.02.0005"       "03.51"
"QUALITY8"              "DB2CLI.DLL"     "08.02.0006"     "03.52.0000"

Server_Name
     "DB2     "

Any suggestions for how to resolve are appreciated!

**************** Elaine McGovern Jones ************************

ISC Tape and DASD Storage Products
    Characterization and Failure Analysis Engineering
      Phone:  408  284 4853  Internal: 3-4853
      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.

Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

RODBC sqlSave with DB2

Thread (2 messages)