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.
I searched R help and found similar problems have been encountered with
Oracle and postgresSQL.
http://www.mail-archive.com/r-help@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...
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
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.
