R : Copyright 2005, The R Foundation for Statistical Computing
Version 2.1.1  (2005-06-20), ISBN 3-900051-07-0

R is free software and comes with ABSOLUTELY NO WARRANTY.
You are welcome to redistribute it under certain conditions.
Type 'license()' or 'licence()' for distribution details.

R is a collaborative project with many contributors.
Type 'contributors()' for more information and
'citation()' on how to cite R or R packages in publications.

Type 'demo()' for some demos, 'help()' for on-line help, or
'help.start()' for a HTML browser interface to help.
Type 'q()' to quit R.

> ### * <HEADER>
> ###
> attach(NULL, name = "CheckExEnv")
> assign(".CheckExEnv", as.environment(2), pos = length(search())) # base
> ## add some hooks to label plot pages for base and grid graphics
> setHook("plot.new", ".newplot.hook")
> setHook("persp", ".newplot.hook")
> setHook("grid.newpage", ".gridplot.hook")
> 
> assign("cleanEx",
+        function(env = .GlobalEnv) {
+ 	   rm(list = ls(envir = env, all.names = TRUE), envir = env)
+            RNGkind("default", "default")
+ 	   set.seed(1)
+    	   options(warn = 1)
+ 	   delayedAssign("T", stop("T used instead of TRUE"),
+ 		  assign.env = .CheckExEnv)
+ 	   delayedAssign("F", stop("F used instead of FALSE"),
+ 		  assign.env = .CheckExEnv)
+ 	   sch <- search()
+ 	   newitems <- sch[! sch %in% .oldSearch]
+ 	   for(item in rev(newitems))
+                eval(substitute(detach(item), list(item=item)))
+ 	   missitems <- .oldSearch[! .oldSearch %in% sch]
+ 	   if(length(missitems))
+ 	       warning("items ", paste(missitems, collapse=", "),
+ 		       " have been removed from the search path")
+        },
+        env = .CheckExEnv)
> assign("..nameEx", "__{must remake R-ex/*.R}__", env = .CheckExEnv) # for now
> assign("ptime", proc.time(), env = .CheckExEnv)
> grDevices::postscript("RODBC-Examples.ps")
> assign("par.postscript", graphics::par(no.readonly = TRUE), env = .CheckExEnv)
> options(contrasts = c(unordered = "contr.treatment", ordered = "contr.poly"))
> options(warn = 1)    
> library('RODBC')
> 
> assign(".oldSearch", search(), env = .CheckExEnv)
> assign(".oldNS", loadedNamespaces(), env = .CheckExEnv)
> cleanEx(); ..nameEx <- "RODBC"
> 
> ### * RODBC
> 
> flush(stderr()); flush(stdout())
> 
> ### Name: RODBC
> ### Title: ODBC Database Connectivity
> ### Aliases: RODBC
> ### Keywords: IO database
> 
> ### ** Examples
> 
> ## Not run: 
> ##D data(USArrests) # R < 2.0.0 only
> ##D channel <- odbcConnect("test")
> ##D sqlSave(channel, USArrests, rownames = "State", verbose = TRUE)
> ##D sqlQuery(channel, paste("select State, Murder from USArrests",
> ##D                         "where Rape > 30 order by Murder"))
> ##D sqlFetch(channel, "USArrests", rownames = "State")
> ##D sqlDrop(channel, "USArrests")
> ##D close(channel)
> ## End(Not run)
> 
> 
> cleanEx(); ..nameEx <- "RODBCtables"
> 
> ### * RODBCtables
> 
> flush(stderr()); flush(stdout())
> 
> ### Name: RODBCtables
> ### Title: Operations on Tables in ODBC databases
> ### Aliases: sqlPrimaryKeys sqlColumns sqlDrop sqlClear
> ### Keywords: IO database
> 
> ### ** Examples
> 
> ## Not run: 
> ##D ## example results from MySQL
> ##D data(USArrests) # R < 2.0.0 only
> ##D channel <- odbcConnect("test")
> ##D sqlDrop(channel, "USArrests", errors = FALSE) # precautionary
> ##D sqlSave(channel, USArrests)
> ##D sqlColumns(channel, "USArrests")
> ##D sqlColumns(channel, "USArrests", special = TRUE)
> ##D sqlPrimaryKeys(channel, "USArrests")
> ##D sqlColumns(channel, "USArrests")
> ##D ##   Table_cat Table_schema Table_name Column_name Data_type Type_name
> ##D ## 1                         USArrests    rownames        12   varchar
> ##D ## 2                         USArrests      murder         8    double
> ##D ## 3                         USArrests     assault         4   integer
> ##D ## 4                         USArrests    urbanpop         4   integer
> ##D ## 5                         USArrests        rape         8    double
> ##D ##   Column_size Buffer_length Decimal_digits Num_prec_radix Nullable Remarks
> ##D ## 1         255           255           <NA>           <NA>        0
> ##D ## 2          22             8             31             10        1
> ##D ## 3          11             4              0             10        1
> ##D ## 4          11             4              0             10        1
> ##D ## 5          22             8             31             10        1
> ##D sqlColumns(channel, "USArrests", special = TRUE)
> ##D ##   Scope Column_name Data_type Type_name Precision Length Scale
> ##D ## 1     2    rownames        12   varchar         0      0     0
> ##D ##   Pseudo_column
> ##D ## 1             1
> ##D sqlPrimaryKeys(channel, "USArrests")
> ##D ##   Table_qualifer Table_owner Table_name Column_name Key_seq Pk_name
> ##D ## 1           <NA>        <NA>  USArrests    rownames       1 PRIMARY
> ##D sqlClear(channel, "USArrests")
> ##D sqlDrop(channel, "USArrests")
> ##D close(channel)
> ## End(Not run)
> 
> 
> cleanEx(); ..nameEx <- "odbcConnect"
> 
> ### * odbcConnect
> 
> flush(stderr()); flush(stdout())
> 
> ### Name: odbcConnect
> ### Title: ODBC Open Connections
> ### Aliases: odbcConnect odbcDriverConnect odbcReConnect print.RODBC
> ### Keywords: IO database
> 
> ### ** Examples
> ## Not run: 
> ##D # MySQL
> ##D channel <- odbcConnect("test", uid="ripley", pwd="secret")
> ##D # PostgreSQL
> ##D channel <- odbcConnect("pg", uid="ripley", pwd="secret", case="postgresql")
> ##D 
> ##D # re-connection
> ##D odbcCloseAll()
> ##D channel <- odbcReConnect(channel) # must re-assign as the data may well change
> ## End(Not run)
> 
> 
> cleanEx(); ..nameEx <- "odbcGetInfo"
> 
> ### * odbcGetInfo
> 
> flush(stderr()); flush(stdout())
> 
> ### Name: odbcGetInfo
> ### Title: Request Information on an ODBC Connection
> ### Aliases: odbcGetInfo
> ### Keywords: IO database
> 
> ### ** Examples
> ## Not run: 
> ##D odbcGetInfo(channel) # under Windows XP
> ##D ## MySQL returned
> ##D              DBMS_Name               DBMS_Ver        Driver_ODBC_Ver
> ##D                "MySQL"           "4.0.20a-nt"                "03.51"
> ##D       Data_Source_Name            Driver_Name             Driver_Ver
> ##D              "testdb3"          "myodbc3.dll"             "03.51.09"
> ##D               ODBC_Ver            Server_Name
> ##D           "03.52.0000" "localhost via TCP/IP"
> ##D ## MS Access returned
> ##D        DBMS_Name         DBMS_Ver  Driver_ODBC_Ver Data_Source_Name
> ##D         "ACCESS"     "04.00.0000"          "03.51"        "testacc"
> ##D      Driver_Name       Driver_Ver         ODBC_Ver      Server_Name
> ##D   "odbcjt32.dll"     "04.00.6304"     "03.52.0000"         "ACCESS"
> ##D ## MSDE 2000 returned
> ##D              DBMS_Name               DBMS_Ver        Driver_ODBC_Ver
> ##D "Microsoft SQL Server"           "08.00.0760"                "03.52"
> ##D       Data_Source_Name            Driver_Name             Driver_Ver
> ##D                 "MSDE"         "SQLSRV32.DLL"           "03.85.1117"
> ##D               ODBC_Ver            Server_Name
> ##D           "03.52.0000"                  "AUK"
> ## End(Not run)
> 
> 
> cleanEx(); ..nameEx <- "setSqlTypeInfo"
> 
> ### * setSqlTypeInfo
> 
> flush(stderr()); flush(stdout())
> 
> ### Name: setSqlTypeInfo
> ### Title: Specify a Mapping of R Types to DBMS Types
> ### Aliases: setSqlTypeInfo getSqlTypeInfo
> ### Keywords: IO database
> 
> ### ** Examples
> ## Not run: 
> ##D getSqlTypeInfo()
> ##D getSqlTypeInfo("MySQL")
> ##D setSqlTypeInfo("SQLServer",
> ##D                list(double="float", integer="int",
> ##D                     character="varchar(255)", logical="varchar(5)"))
> ## End(Not run)
> 
> 
> cleanEx(); ..nameEx <- "sqlCopy"
> 
> ### * sqlCopy
> 
> flush(stderr()); flush(stdout())
> 
> ### Name: sqlCopy
> ### Title: ODBC Copy
> ### Aliases: sqlCopy sqlCopyTable
> ### Keywords: IO database
> 
> ### ** Examples
> ## Not run: 
> ##D ## example for a l/casing DBMS
> ##D sqlSave(channel, USArrests, rownames = "state")
> ##D query <- paste("select state, murder from usarrests",
> ##D                "where rape > 30", "order by murder")
> ##D sqlCopy(channel, query, "HighRape", rownames = FALSE)
> ##D sqlFetch(channel, "HighRape", rownames = "state", max = 5)
> ##D sqlDrop(channel, "HighRape")
> ## End(Not run)
> 
> 
> cleanEx(); ..nameEx <- "sqlFetch"
> 
> ### * sqlFetch
> 
> flush(stderr()); flush(stdout())
> 
> ### Name: sqlFetch
> ### Title: Reading Tables from ODBC Databases
> ### Aliases: sqlFetch sqlFetchMore
> ### Keywords: IO database
> 
> ### ** Examples
> 
> ## Not run: 
> ##D data(USArrests) # R < 2.0.0 only
> ##D channel <- odbcConnect("test")
> ##D sqlSave(channel, USArrests, verbose = TRUE)
> ##D sqlFetch(channel, "USArrests") # get the lot
> ##D sqlFetch(channel, "USArrests", max=20)
> ##D sqlFetchMore(channel, max=20)
> ##D sqlFetchMore(channel) # get the rest
> ##D sqlDrop(channel, "USArrests") 
> ##D close(channel)
> ## End(Not run)
> 
> 
> cleanEx(); ..nameEx <- "sqlQuery"
> 
> ### * sqlQuery
> 
> flush(stderr()); flush(stdout())
> 
> ### Name: sqlQuery
> ### Title: Query an ODBC Database
> ### Aliases: sqlQuery sqlGetResults
> ### Keywords: IO database
> 
> ### ** Examples
> 
> ## Not run: 
> ##D data(USArrests) # R < 2.0.0 only
> ##D channel <- odbcConnect("test")
> ##D sqlSave(channel, USArrests, rownames = "State", verbose = TRUE)
> ##D # options(dec=".") # optional, if DBMS is not locale-aware
> ##D ## note case of State, Murder, rape are DBMS-dependent.
> ##D sqlQuery(channel, paste("select State, Murder from USArrests",
> ##D                         "where Rape > 30 order by Murder"))
> ##D close(channel)
> ## End(Not run)
> 
> 
> cleanEx(); ..nameEx <- "sqlSave"
> 
> ### * sqlSave
> 
> flush(stderr()); flush(stdout())
> 
> ### Name: sqlSave
> ### Title: Write a Data Frame to a Table in an ODBC Database
> ### Aliases: sqlSave sqlUpdate
> ### Keywords: IO database
> 
> ### ** Examples
> 
> ## Not run: 
> ##D data(USArrests) # R < 2.0.0 only
> ##D channel <- odbcConnect("test")
> ##D sqlSave(channel, USArrests, rownames = "state", addPK=TRUE)
> ##D sqlFetch(channel, "USArrests", rownames = "state") # get the lot
> ##D foo <- cbind(state=row.names(USArrests), USArrests)[1:3, c(1,3)]
> ##D foo[1,2] <- 222
> ##D sqlUpdate(channel, foo, "USArrests")
> ##D sqlFetch(channel, "USArrests", rownames = "state", max = 5)
> ##D sqlDrop(channel, "USArrests") 
> ##D close(channel)
> ## End(Not run)
> 
> 
> cleanEx(); ..nameEx <- "sqlTables"
> 
> ### * sqlTables
> 
> flush(stderr()); flush(stdout())
> 
> ### Name: sqlTables
> ### Title: List Tables on an ODBC Database
> ### Aliases: sqlTables
> ### Keywords: IO database
> 
> ### ** Examples
> 
> ## Not run: 
> ##D channel <- odbcConnect("test")
> ##D sqlTables(channel, "USArrests")
> ##D ## MySQL example
> ##D ##   Table_qualifer Table_owner Table_name Table_type     Remarks
> ##D ##1                             usarrests      TABLE MySQL table
> ##D ## Microsoft Access example
> ##D ##      TABLE_CAT TABLE_SCHEM        TABLE_NAME   TABLE_TYPE REMARKS
> ##D ##1 C:\bdr\test        <NA> MSysAccessObjects SYSTEM TABLE    <NA>
> ##D ##2 C:\bdr\test        <NA>          MSysACEs SYSTEM TABLE    <NA>
> ##D ##3 C:\bdr\test        <NA>       MSysObjects SYSTEM TABLE    <NA>
> ##D ##4 C:\bdr\test        <NA>       MSysQueries SYSTEM TABLE    <NA>
> ##D ##5 C:\bdr\test        <NA> MSysRelationships SYSTEM TABLE    <NA>
> ##D ##6 C:\bdr\test        <NA>             hills        TABLE    <NA>
> ##D ##7 C:\bdr\test        <NA>         USArrests        TABLE    <NA>
> ##D close(channel)
> ## End(Not run)
> 
> 
> ### * <FOOTER>
> ###
> cat("Time elapsed: ", proc.time() - get("ptime", env = .CheckExEnv),"\n")
Time elapsed:  0.1 0.01 0.11 0 0 
> grDevices::dev.off()
null device 
          1 
> ###
> ### Local variables: ***
> ### mode: outline-minor ***
> ### outline-regexp: "\\(> \\)?### [*]+" ***
> ### End: ***
> quit('no')