search for: table_qualifi

...INT ezone_locationprice_year1_pkey PRIMARY KEY (ezone) ) WITHOUT OIDS; ALTER TABLE scen990.ezone_locationprice_year1 OWNER TO mscope; COMMENT ON TABLE scen990.ezone_locationprice_year1 IS 'calculated'; The RODBC function sqlTables() returns all the tables, but the records look like this: TABLE_QUALIFIER TABLE_OWNER TABLE_NAME TABLE_TYPE REMARKS mscope scen990 ezone_locationprice_year1 TABLE "" All the "REMARKS" values are empty strings. Can I get it to return the COMMENT ON values instead? (the table_owner and tablet_qualifier are switched b...

...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, "PRICES.DB_PRICES") Error in odbcTableExists(channel, sqtable) : 'PRICES.DB_PRICES': table not found on channel A...

...d be appreciated. ##-------------------------------------------------------------------------------## > library(RODBC) > con <- odbcConnect("BIGSKY","***","**********") > con RODB Connection 0 Details: case=nochange 0?????????? > sqlTables(con) [1] TABLE_QUALIFIER TABLE_OWNER TABLE_NAME TABLE_TYPE [5] REMARKS <0 rows> (or 0-length row.names) > sqlQuery(con,"select * from Medium") [1] "[RODBC] ERROR: Could not SQLExecute" [2] "S1000 1 [u...

...ery("SELECT * FROM X.test"). However, I can't get the columns in table X.test with sqlColumns(db,"X.test") //it returns Error in sqlColumns(db, "X.test") : 'X.test': table not found on channel If I do sqlColumns(db, "test") it returns [1] TABLE_QUALIFIER TABLE_OWNER TABLE_NAME COLUMN_NAME DATA_TYPE [6] TYPE_NAME PRECISION LENGTH SCALE RADIX [11] NULLABLE REMARKS COLUMN_DEF SQL_DATA_TYPE SQL_DATETIME_SUB [16] CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLABLE...

...user, as in my case. (1, may be Davids comment already solves this?) There are still some problems with sqlTables() and sqlQuery() which should return a data.frame, but only return one line. I tried with MS Access and Oracle, and now odbcGetErrMsg() somewhat explains the problem. sqlTables(0) TABLE_QUALIFIER TABLE_OWNER TABLE_NAME TABLE_TYPE REMARKS 1 C:\\TEMP\\db NA MSysACEs SYSTEM TABLE NA Browse[1]> odbcGetErrMsg(channel) [1] "[RODBC]ERROR: Row count not supported" Why is this? If it is generally possible, that some ODBC drivers do not support Row count, then we...