Hi
I am new in the R world and hopefully this is the right forum to ask.
My backend is an Ingres database to which I connect via ODBC
I have defined a DSN which connects ok to myh backend
But when I try the following
library(RODBC)
channel <- odbcConnect("pirar01")
load("a.rdata")
sqlSave(channel, a, tablename = "Table1", append = FALSE, rownames = FALSE,
colnames = FALSE, verbose = TRUE)
It fails:
Query: INSERT INTO "Table1" ( "strategy", "par1", "par2", "par3", "par4",
"par5", "par6", "timeinmarket", "totalprofit", "annualizedreturns",
"annualizedvol", "informationratio", "ewar", "maxdd", "sp500corr",
"rsquared", "avgholding", "maxholding", "meanmktdayreturn",
"probmktdayprofit" ) VALUES ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? )
Error in odbcUpdate(channel, query, mydata, coldata[m, ], test = test, :
missing columns in 'data'
The table gets created but it is empty
Any ideas , suggestions ?
Thanks
--
View this message in context:
http://r.789695.n4.nabble.com/RODBC-help-tp3235377p3235377.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
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.
