odbc-query: Execute a statement on a given database connection.

In RODBCDBI: Provides Access to Databases Through the ODBC Interface

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.

RODBCDBI documentation built on May 2, 2019, 5:56 a.m.