DBIResult-class {DBI} | R Documentation |
Base class for all DBMS-specific result objects.
A virtual Class: No objects may be created from it.
Class "DBIObject"
, directly.
The main generator is dbSendQuery
.
signature(res = "DBIResult", n = "numeric")
: ... signature(res = "DBIResult", n = "missing")
: ... signature(res = "DBIResult")
: ... Meta-data:
signature(res = "DBIResult")
: ... signature(conn = "DBIResult")
: ... signature(dbObj = "DBIResult")
: ... signature(res = "DBIResult")
: ... signature(res = "DBIResult")
: ... signature(res = "DBIResult")
: ... signature(res = "DBIResult")
: ... signature(conn = "DBIResult", name = "missing")
: ... signature(object = "DBIResult")
: ... signature(from = "DBIConnection", to = "DBIResult")
: ... R-SIG-DB
See the Database Interface definition document
DBI.pdf
in the base directory of this package
or http://developer.r-project.org/db.
DBI classes:
DBIObject-class
DBIDriver-class
DBIConnection-class
DBIResult-class
## Not run: drv <- dbDriver("Oracle") con <- dbConnect(drv, "user/password@dbname") res <- dbSendQuery(con, "select * from LASERS where prdata > '2002-05-01'") summary(res) while(dbHasCompleted(res)){ chunk <- fetch(res, n = 1000) process(chunk) } ## End(Not run)