dbi.table (version 1.0.3)

dbExecute,dbi.catalog,SQL-method: DBI Methods for dbi.tables

Description

Call DBI methods using the underlying DBI connection.

Usage

# S4 method for dbi.catalog,SQL
dbExecute(conn, statement, ...)
# S4 method for dbi.schema,SQL
dbExecute(conn, statement, ...)
# S4 method for dbi.table,SQL
dbExecute(conn, statement, ...)
# S4 method for dbi.table,missing
dbSendStatement(
  conn,
  statement,
  ...,
  n = getOption("dbi_table_max_fetch", 10000L)
)
# S4 method for dbi.table,missing
dbGetQuery(conn, statement, ..., n = getOption("dbi_table_max_fetch", 10000L))
# S4 method for dbi.catalog
dbGetInfo(dbObj, ...)
# S4 method for dbi.schema
dbGetInfo(dbObj, ...)
# S4 method for dbi.table
dbGetInfo(dbObj, ...)

Arguments

conn

a dbi.catalog, dbi.schema, or dbi.table.

statement

a SQL object.

...

other parameters passed on to methods.

n

an integer value. A nonnegative value limits the number of records returned by the query. A negative value omits the LIMIT (or TOP) clause entirely.

dbObj

a dbi.catalog, dbi.schema, or dbi.table.

See Also

dbExecute, dbGetInfo, dbSendStatement