Description Usage Arguments Methods See Also
JDBCQueryResult class
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 | ## S4 method for signature 'JDBCQueryResult,numeric'
dbFetch(res, n = -1, fetch_size = 0,
..., row.names = NA)
## S4 method for signature 'JDBCQueryResult'
dbClearResult(res, ...)
## S4 method for signature 'JDBCQueryResult'
dbColumnInfo(res, what = c("name", "field.type",
"data.type", "jdbc.type"), ...)
## S4 method for signature 'JDBCQueryResult'
dbGetRowCount(res, ...)
## S4 method for signature 'JDBCQueryResult'
dbGetRowsAffected(res, ...)
## S4 method for signature 'JDBCQueryResult'
dbHasCompleted(res, ...)
## S4 method for signature 'JDBCQueryResult'
dbGetInfo(dbObj, ...)
## S4 method for signature 'JDBCQueryResult'
dbIsValid(dbObj, ...)
## S4 method for signature 'JDBCQueryResult'
dbGetDriver(dbObj, ...)
## S4 method for signature 'JDBCQueryResult'
dbGetStatement(res, ...)
## S4 method for signature 'JDBCQueryResult'
dbGetRowsAffected(res, ...)
|
res, dbObj |
an |
n |
optional maximum number of records to retrieve per fetch. Use |
fetch_size |
a hint to the number of rows that should be fetched from the database in a single block. See http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#setFetchSize(int). |
... |
Ignored. Needed for compatibility with generic. |
row.names |
Either If A string is equivalent to For backward compatibility, |
what |
a character vector indicating which info to return.
Expected is a subset of |
dbFetch
: Fetch n results
dbColumnInfo
: Get info about the result set data types.
Returns a data.frame with one row per output field in res
.
Includes name
, field.type
(the SQL type)
and data.type
(the R data type) columns for the default what.
Additionally, label
(The field label)
and nullable
(0 = disallows NULL, 1 = allows NULL, 2 = unknown) can be fetched.
dbGetRowCount
: Count rows in result set
dbGetRowsAffected
: This function returns the number of rows
that were added, deleted, or updated by data modifying query.
For a selection query, this function returns 0.
dbHasCompleted
: Check if all results have been fetched
dbGetInfo
: Get info
dbIsValid
: Is the result valid
dbGetStatement
: Returns the statement that was passed to dbSendQuery
dbGetRowsAffected
: Returns 0
Other result classes: JDBCResult-class
,
JDBCUpdateResult-class
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.