search for: table_type

...; summary(rs, verbose=TRUE) <OraResult:(6721,7,2)> Statement: select * from cat Has completed? no Affected rows: 0 Rows fetched: -1 Fields: name Sclass type len precision scale isVarLength nullOK 1 TABLE_NAME character VARCHAR2 30 0 0 TRUE FALSE 2 TABLE_TYPE character VARCHAR2 11 0 0 TRUE TRUE > > myContent <- fetch(rs, n = -1) > myContent [1] TABLE_NAME TABLE_TYPE <0 rows> (or 0-length row.names) > summary(myContent, verbose=TRUE) TABLE_NAME TABLE_TYPE Length:0 Length:0 Class :charac...

...m cat > > Has completed? no > > Affected rows: 0 > > Rows fetched: -1 > > Fields: > > name Sclass type len precision scale > isVarLength nullOK > > 1 TABLE_NAME character VARCHAR2 30 0 0 > TRUE FALSE > > 2 TABLE_TYPE character VARCHAR2 11 0 0 > TRUE TRUE > > > >> > >> myContent <- fetch(rs, n = -1) > >> myContent > >> > > [1] TABLE_NAME TABLE_TYPE > > <0 rows> (or 0-length row.names) > > > >> summary(myConten...

...uot;Scan 1","Scan 2" etc. If I use RODBC, I get back something like this > channel<-odbcConnectExcel(fileName) > tables<-sqlTables(channel) > scanTables<-tables[c(grep("Scan",tables[,"TABLE_NAME"])),] > scanTables TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 16 <NA> 'Scan 1$' TABLE <NA> 4 <NA> 'Scan 10$' TABLE <NA> 5 <NA> 'Scan 11$' TABLE <NA> 6 <NA> 'Scan 12$' TABLE <NA> ... If I try to fetch...

...IMARY KEY, [Name] varchar(50)) 54 SQL:BatchCompleted UPDATE schema_info SET version = 2 54 SQL:BatchCompleted SELECT @@ROWCOUNT AS AffectedRows 54 SQL:BatchCompleted SELECT TOP 1 * FROM schema_info 54 SQL:BatchCompleted SELECT table_name from information_schema.tables WHERE table_type = ''BASE TABLE'' 54 SQL:BatchCompleted SELECT COLUMN_NAME as ColName, COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType, COL_LENGTH(''Foo'', COLUMN_NAME) as Length, COLUMNPROPERTY(OBJECT_ID(''Foo''), COLUMN_NAME, ''IsIdentity''...

...(i.e., test), but that doesn't seem to solve the problem. OK, so lets pretend I don't know what the table in test.dbf is called, and use sqlTables instead: table_list <- sqlTables(import_dat) When I then enter table_list in the console, I get [1] TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS <0 rows> (or 0-length row.names) Meaning, what? It almost seems that its telling me there is nothing in test.dbf. Well, there definitely is (I can open it up in Excel - shudder), but, perhaps it is unable to recognize whats there. Suggestions? Apologies if this is easy, or (wors...

...I did the following: > con RODBC Connection 3 Details: case=nochange DBQ=c:\temp\test.xls DefaultDir=c:\temp Driver={Microsoft Excel Driver (*.xls)} DriverId=790 MaxBufferSize=2048 PageTimeout=5 > tbls <- sqlTables(con) > tbls TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 1 c:\\temp\\test <NA> Sheet1$ SYSTEM TABLE <NA> 2 c:\\temp\\test <NA> Sheet2$ SYSTEM TABLE <NA> 3 c:\\temp\\test <NA> Sheet3$ SYSTEM TABLE <NA> Everything seems to be fine. Then I did > qry <- paste("S...

...Version 1.7.1, Windows XP, Oracle8 ODBC Driver Version 8.1.6.4.0: > library(RODBC) > channel <- odbcConnect(dsn="PAV32", case="oracle", believeNRows=FALSE) > # ok, this was succesful > x <- sqlTables(channel) > x[37, ] TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 37 <NA> TKF ABTGRNAMEN TABLE <NA> > # ok, so the table I am looking for ("ABTGRNAMEN") is there, but: > sqlFetch(channel, "ABTGRNAMEN") [1] "[RODBC] ERROR: Could not SQLExecute" [2] &q...

...DBC? There's an Excel file I am trying to read from, it has one sheet named 'nameclass'. Thanks in anticipation. Vishal Belsare > library(RODBC) > con = odbcConnectExcel(file.choose()) > tbls <- sqlTables(con) > tbls TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 1 T:\\data\\in\\nameclass <NA> nameclass$ SYSTEM TABLE <NA> > qry = paste("SELECT * FROM '",tbls$TABLE_NAME[1],"'",sep="") > result = sqlQuery(con,qry) > result [1] "[RODBC] ERROR: Could not SQLExecDirect" [2]...

...ork $ # Connect to an previously non-existent Excel file $ out <- odbcConnectExcel2007("test.xlsx", readOnly=FALSE) $ test <- data.frame(x=1:10, y=rnorm(10)) $ sqlSave(out, test) $ sqlTables(out) TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 1 C:\\Documents and Settings\\G69974\\My Documents\\test.xlsx <NA> test$ SYSTEM TABLE <NA> 2 C:\\Documents and Settings\\G69974\\My Documents\\test.xlsx <NA> test TABLE <NA> $ sqlFetch(out, "test") x y 1...

...ctly from an excel spreadsheet using the RODBC package. I am getting the following error messages, wondering if anyone can help me with it?   > connection = odbcConnectExcel('D:\\R files\\TestData.xls') > tables = sqlTables(connection) > tables    TABLE_CAT TABLE_SCHEM  TABLE_NAME TABLE_TYPE REMARKS 1 D:\\R files\\TestData        <NA> '30092007$'      TABLE    <NA> 2 D:\\R files\\TestData        <NA> '30092008$'      TABLE    <NA> 3 D:\\R files\\TestData        <NA> '31032007$'      TABLE    <NA> 4 D:\\R files\\TestData       ...

...azionale mod <NA> 'emi tot 2006$' 5 c:\\TABELLE DEFINITIVE\\nuova tabella terapia occupazionale mod <NA> 'RMI E SCALA SPECIFICA$' 6 c:\\TABELLE DEFINITIVE\\nuova tabella terapia occupazionale mod <NA> 'VALORI RANKIN RMI CSS$' TABLE_TYPE REMARKS 1 TABLE <NA> 2 TABLE <NA> 3 TABLE <NA> 4 TABLE <NA> 5 TABLE <NA> 6 TABLE <NA> > table1=sqlFetch(channel,"emi tot 2006 OAI_60g TO FU1$") > str(table1) chr [1:2] "[RODBC] ERROR: Could not...

...ne) ) 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 but that doesn't worry me) I'm using R...

...s. 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 Are their other options I should be using with...

Hi, I''m trying to use rails to build a model from a database view. I get this output C:\dev\v6\project>ruby script/generate scaffold Assignment ... error Before updating scaffolding from new DB schema, try creating a tab le for your model (Assignment) Is this not possible in Rails? It would be *really* helpful for my application. -------------- next part -------------- An

...ta files large enough in CSV format RODBC could be helpful) . I set up a DNS called "Text Files" and then ran the following code in R > library(RODBC) > mtg <- odbcConnect("Text Files") > sqlTables(mtg) TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 1 C:\\USERS\\NUTTERB <NA> Core2012.txt TABLE <NA> 2 C:\\USERS\\NUTTERB <NA> MTGCards.csv TABLE <NA> > sqlFetch(mtg, "MTGCards.csv") Error in odbcTable...

...----------------------------------------------------## > 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 [unixODBC] Msg 208, Level 16, State 1, Server B...

...channnel = MDB, "SELECT gebiedscode FROM ganzengebieden;") Error in sqlQuery(channnel = MDB, "SELECT gebiedscode FROM ganzengebieden;") : first argument is not an open RODBC channel > sqlTables(channel = MDB) #truncated output! TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 13 <NA> ganzengebieden TABLE <NA> > sqlFetch(channel = MDB, 'ganzengebieden') #makes R crash > sessionInfo() R version 2.15.2 (2012-10-26) Platform: i386-w64-mingw32/i386 (32-bit) locale: [1] LC_COLLATE=Dutch_Belgium.1252 LC_CTYPE...

...earch_databaseI <NA> 21 C:\\Users\\satimiswin764\\Documents\\research_databaseI <NA> 22 C:\\Users\\satimiswin764\\Documents\\research_databaseI <NA> 23 C:\\Users\\satimiswin764\\Documents\\research_databaseI <NA> TABLE_NAME TABLE_TYPE REMARKS 1 AGR$ SYSTEM TABLE <NA> 2 BMC$ SYSTEM TABLE <NA> 3 Dairy$ SYSTEM TABLE <NA> 4 GDP$ SYSTEM TABLE <NA> 5 HIES$ SYSTEM TABLE &l...

Hello, I am trying to play with RODBC library and Excel Files. In my file (doubs.xls) there are 2 spreadsheets: > library(RODBC) > connection<-odbcConnect("Excel Files") > sqlTables(connection) TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 1 F:\\Th?se\\R\\Doubs NA Faune$ SYSTEM TABLE NA 2 F:\\Th?se\\R\\Doubs NA Milieu$ SYSTEM TABLE NA I have two problems. (1) For loading the tables in R, I use > sqlFetch(connection,"Faune$") [1] "37000 -3506 [Microsoft][Pilote ODBC Exc...

...ODBC or RMySQL to connect to my database i can't see these accentuated characters: library(RODBC) con <-odbcConnect("trybunal", uid="root", pwd="mypassword") sqlTable(con) the output (abridged) is like that: TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 14 trybunal Wyk?adnia innych przepis<f3>w TABLE MySQL instead of <F3> i should see "?" and instead of ? a "?". It is just the same if i use RMySQL instead of RODBC: library(RMySQL) con <-dbConnect(dbDriver("MySQL"), dbname=&...