callSQL: Call SQL Query

In blazickjoe/DataScienceLibrary: DKS R Functions

Description

Call to 32bit R for SQL Query. Handles both with specified external Query to fix for legacy code that had this dependency and new code where queryLoc does not need to be specified.

Usage

callSQL(query, queryLoc = NA, tempPath = NA, db = NA, username = NA,
  password = NA)

Arguments

query	String that is the query to be exectuted.
queryLoc	DEPRICATED Specify the location of the RScript with SQL function to be executed.
tempPath	Set to tempdir but can be any directory, defaults to AppData tempdir.
db	Database being queried.
username	Username for the database being queried.
password	Password for the database being queried.

Value

Returns table from SQL query.

blazickjoe/DataScienceLibrary documentation built on Nov. 5, 2019, 2:26 p.m.