dbSendQuery,ODBCConnection-method {RODBCDBI}

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

## S4 method for signature 'ODBCConnection'
dbSendQuery(conn, statement, ...)

## S4 method for signature 'ODBCResult'
dbFetch(res, n = -1, ...)

## S4 method for signature 'ODBCResult'
dbHasCompleted(res, ...)

## S4 method for signature 'ODBCResult'
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.