RJDBC (version 0.2-4)

JDBCConnection-methods: Methods for the class `JDBCConnect' in Package `RJDBC'

Description

Methods for the class `JDBCConnection' in Package `RJDBC'.

dbSendQuery and dbSendUpdate submit a SQL query to the database. The difference between the two is only that dbSendUpdate is used with DBML queries and thus doesn't return any result set.

dbGetTables and dbGetFields are similar to dbListTables and dbListFields but the result is a data frame with all available details (whereas the latter return only a character vector of the names).

Usage

dbSendUpdate (conn, statement, ...)
dbGetTables (conn, ...)
dbGetFields (conn, ...)

Arguments

conn

connection object

statement

SQL statement to execute

...

additional arguments to prepared statement substituted for "?"