Learn R Programming
RODBCDBI (version 0.1.1)

dbSendQuery,ODBCConnection-method: Execute a statement on a given database connection.

Description

To retrieve results a chunk at a time, use dbSendQuery, dbFetch, then ClearResult. Alternatively, if you want all the results (and they'll fit in memory) use dbGetQuery which sends, fetches and clears for you.

Usage

"dbSendQuery"(conn, statement, ...)


"dbFetch"(res, n = -1, ...)


"dbHasCompleted"(res, ...)


"dbClearResult"(res, ...)

Arguments

conn
An existing ODBCConnection
statement
The SQL which you want to run
...
Other parameters passed on to methods
res
An object of class ODBCResult
n
Number of rows to return. If less than zero returns all rows.