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.