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-7 Index]