mydbGetQuery: Retrieve a table from a JDBC connection and return a...

In sachsmc/rreporttools: A small set of tools for performing common reporting tasks

Description

This function extends dbGetQuery by setting the column names to lower case, and optionally returning the result as an indexed data.table. This is extremely useful for large queries.

Usage

mydbGetQuery(conn, statement, data.table = TRUE, key = NULL, ...)

Arguments

conn	Connection object to database. See dbConnect
statement	Character string containing SQL statement. Do not end with a semicolon
data.table	Logical, return resulting object as a data.table.
key	Character string indicating which variable to use as the index. Ignored if data.table = FALSE.
...	expressions passed to dbSendQuery()

Examples

#mydbGetQuery(conn, "select * from all_tables", TRUE, "owner")

sachsmc/rreporttools documentation built on May 29, 2019, 12:55 p.m.