Displaying 1 result from an estimated 1 matches for "commod_curv".
Did you mean:
commod_curve
2008 Feb 05
1
SAS ODBC
...'s 9.1 ODBC driver
and the RODBC package. I'm running R-2.6.1 on Win XP. I can successfully
connect to the database, but no matter which table I query, I get back
an empty table with only the column headers. For example:
> sqlQuery(con, "select * from PRICES.DB_PRICES")
[1] COMMOD_CURVE START_DATE PRICING_DATE PRICE
<0 rows> (or 0-length row.names)
sqlTables also returns back an empty table:
> sqlTables(con)
[1] TABLE_QUALIFIER TABLE_OWNER TABLE_NAME TABLE_TYPE
REMARKS
<0 rows> (or 0-length row.names)
And sqlFetch doesn't work...