Hi,
I am trying to use sqlSave to write a dataframe to an existing table in a
DB2 database. The database contains two schemas. My experience is the
following: (1) in the case that tablename is left empty in sqlSave, R
writes to the instance level schema (2) in the case that a tablename is
specified and that table name exists only once in the database, R will
write to that table irrespective of the schema in which it resides (3) in
the case that a tablename is specified and the table name appears in more
than one schema in the database, R seems to be concatenating the fields
from both tables and thus the sqlSave does not work.
Searching the archives, the most recent discussion on this issue that I
could find was: http://tolstoy.newcastle.edu.au/R/e3/help/07/11/3373.html
where it was suggested to set schema prior to sqlSave. This does not work.
Below is the error as well as traceback():
>
sqlSave(myConnection,merged,tablename="PCCSLANOTMETBYSEVERITY",append=T,rownames=F,colnames=F,verbose=T,oldstyle=F,
safer=TRUE,addPK=F,fast=F,test=FALSE,nastring="")
Error in dimnames(x) <- dn :
length of 'dimnames' [2] not equal to array
extent>
> traceback()
3: `colnames<-`(`*tmp*`, value = c("COC_ID",
"ACCOUNT_ID", "COMPETENCY",
"SERVICE_LINE", "WORKSTREAM_ID", "SPC_LEVEL",
"SNAPSHOT_ID",
"SEVERITY_ID", "MR", "PERCENTSLA_NOTMET",
"TIME_STAMP", "WID",
"ACCOUNT_NAME", "SNAPSHOT_ID", "SEVERITY_ID",
"MR",
"PERCENTSLA_NOTMET",
"TIME_STAMP", "WID"))
2: sqlwrite(channel, tablename, dat, verbose = verbose, fast = fast,
test = test, nastring = nastring)
1: sqlSave(myConnection, merged, tablename = "PCCSLANOTMETBYSEVERITY",
append = T, rownames = F, colnames = F, verbose = T, oldstyle = F,
safer = TRUE, addPK = F, fast = F, test = FALSE, nastring =
"")>
The fields in italic in 3: are from table PCCSLANOTMETBYSEVERITY in one
schema in the db and the remaining fields are from table
PCCSLANOTMETBYSEVERITY in the other schema in the db. R appears to be
concatenating the fields from the tables in both schemas, uncertain to
which table I wish to write.
Does sqlSave allow one to specify table name and schema when writing out a
dataframe?
Thanks.
Aliza
[[alternative HTML version deleted]]
