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

1
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

Want to suggest features or report bugs for rdrr.io? Use the GitHub issue tracker.