DBIResult-class {DBI}R Documentation

Class DBIResult

Description

Base class for all DBMS-specific result objects.

Objects from the Class

A virtual Class: No objects may be created from it.

Extends

Class "DBIObject", directly.

Generator

The main generator is dbSendQuery.

Methods

Fetching methods:

fetch
signature(res = "DBIResult", n = "numeric"): ...
fetch
signature(res = "DBIResult", n = "missing"): ...
Close result set:

dbClearResult
signature(res = "DBIResult"): ...

Meta-data:

dbColumnInfo
signature(res = "DBIResult"): ...
dbGetException
signature(conn = "DBIResult"): ...
dbGetInfo
signature(dbObj = "DBIResult"): ...
dbGetRowCount
signature(res = "DBIResult"): ...
dbGetRowsAffected
signature(res = "DBIResult"): ...
dbGetStatement
signature(res = "DBIResult"): ...
dbHasCompleted
signature(res = "DBIResult"): ...
dbListFields
signature(conn = "DBIResult", name = "missing"): ...
summary
signature(object = "DBIResult"): ...
coerce
signature(from = "DBIConnection", to = "DBIResult"): ...

Author(s)

R-SIG-DB

References

See the Database Interface definition document DBI.pdf in the base directory of this package or http://developer.r-project.org/db.

See Also

DBI classes: DBIObject-class DBIDriver-class DBIConnection-class DBIResult-class

Examples

## 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)

[Package DBI version 0.2-4 Index]