Displaying 1 result from an estimated 1 matches for "pricing_date".
2008 Feb 05
1
SAS ODBC
...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 either:
> sqlFetch(con...