qry_eds: Query EDS Database from 32bit R

In christian-million/researchR:

Description

Using a 32bit ODBC connection to the EDS Database, this function will run a SQL script using your systems 32bit version of R. It will return the results of that query.

Usage

qry_eds(SQL, network = NULL)

Arguments

SQL	A character vector that contains appropriate SQL for the EDS database.

Details

You need to have an ODBC connection to the EDS Database, named "Research". You also need the DBI package installed.

This function creates a temporary directory in the current working directory, and then saves the result of the 32bit query to EDS database in that temp directory. It then reads in that data, and cleans up the temporary files.

Value

A dataframe

Examples

# Do not run
SQL <- "SELECT TERM_BASIC.TERM_ID,
FROM TERM_BASIC
WHERE ( TERM_BASIC.SCHOOL  IN  ( 'CC'  ) )"
# qry_eds(SQL)

christian-million/researchR documentation built on May 15, 2019, 12:45 p.m.