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