Learn R Programming

odbc (version 1.3.5)

OdbcResult: Odbc Result Methods

Description

Implementations of pure virtual functions defined in the DBI package for OdbcResult objects.

Usage

# S4 method for OdbcResult
dbClearResult(res, ...)

# S4 method for OdbcResult dbFetch(res, n = -1, ...)

# S4 method for OdbcResult dbHasCompleted(res, ...)

# S4 method for OdbcResult dbIsValid(dbObj, ...)

# S4 method for OdbcResult dbGetStatement(res, ...)

# S4 method for OdbcResult dbColumnInfo(res, ...)

# S4 method for OdbcResult dbGetRowCount(res, ...)

# S4 method for OdbcResult dbGetRowsAffected(res, ...)

# S4 method for OdbcResult dbBind(res, params, ..., batch_rows = getOption("odbc.batch_rows", NA))

Arguments

res

An object inheriting from DBIResult.

...

Other arguments passed on to methods.

n

maximum number of records to retrieve per fetch. Use n = -1 or n = Inf to retrieve all pending records. Some implementations may recognize other special values.

dbObj

An object inheriting from DBIObject, i.e. DBIDriver, DBIConnection, or a DBIResult

params

A list of bindings, named or unnamed.

batch_rows

The number of rows to retrieve. Defaults to NA, which is set dynamically to the size of the input. Depending on the database, driver, dataset and free memory setting this to a lower value may improve performance.