Learn R Programming

sqlutils (version 1.2)

execQuery: Executes the specified query and returns a data frame. This function currently supports RODBC, RSQLite, and RMySQL. For other databases, use getQuery() and execute the SQL statement using the appropriate database connection.

Description

Executes the specified query and returns a data frame. This function currently supports RODBC, RSQLite, and RMySQL. For other databases, use getQuery() and execute the SQL statement using the appropriate database connection.

Usage

execQuery(query = NULL, connection = NULL, maxLevels = 20, ...)

Arguments

query
the query to execute.
connection
the database connection.
maxLevels
the maximum number of levels a factor can have before being converted to a character. Set to NULL to not recode.
...
other parameters passed to getSQL and sqlexec.

See Also

sqlexec, cacheQuery