| JDBCResult-methods {RJDBC} | R Documentation |
Methods for the class ‘JDBCResult’ in Package ‘RJDBC’.
fetch retrieves the content of the result set in the form of a
data frame. If n is -1 then the current implementation fetches
32k rows first and then (if not sufficient) continues with chunks of
512k rows, appending them. If the size of the result set is known in
advance, it is most efficient to set n to that size.
Additional argument block can be used to inform the driver
that pre-fetching of a certain block of records is desirable
(see setFetchSize() in JDBC) leading to possibly faster pulls
of large queries. The default is to pre-fetch 2048 records. Note
that some databases (like Oracle) don't support a fetch size of more
than 32767. If set to NA or anything less than 1 then the
fetch size is not changed. This is only a hint, drivers are free to
ignore it.
Finally, use.label logical argument determines whether
column lables are used for naming (TRUE, default) or column
names should be used (FALSE) since some database drivers do not
implement labels correctly.
dbClearResult releases the result set.
dbColumnInfo returns basic information about the columns
(fields) in the result set.
dbGetInfo returns an empty list.
dbListResults returns an empty list and warns that JDBC doesn't
track results.
signature(res = "JDBCResult", ...)
signature(res = "JDBCResult", ...)
signature(res = "JDBCResult", ...)
signature(res = "JDBCResult", ...)
signature(res = "JDBCResult", ...)