sqlQuery.cached: Query an ODBC Database (Cached)

In erikjandevries/r.dstools.ej: Data Science Tools by Erik Jan

Description

Wrapper functions to implement caching for the sqlQuery function using RDS-files.

Usage

sqlQuery.cached(rds, channel, query, ...)

Arguments

rds	The name of the file in which the cache is to be stored.
channel	Connection handle as returned by odbcConnect.
query	Any valid SQL statement.
...	Additional arguments to be passed to sqlQuery.

Details

If the rds file exists, the object will be loaded from the rds. Otherwise the query will be sent to the ODBC database via the\ channel, and an rds of the returned object will be saved.

See Also

do.call.cached which is the wrapper function that performs the caching.

sqlQuery which is called to submit the query to an ODBC database, and retrieve the results.

Examples

sqlQuery.cached(dbHandle, "SELECT COUNT(*) FROM CUSTOMERS")

erikjandevries/r.dstools.ej documentation built on May 24, 2019, 4:02 a.m.