DBI_getOBDCtable: Get Table from OBDC connection
In MARC-KC/marcR: Helpful Functions Used By The MARC-GIS Team

DBI_getOBDCtable

R Documentation

Get Table from OBDC connection

Description

Usage

DBI_getOBDCtable(conn, query, roundRealDigits = NULL)

Arguments

`conn`	A `DBIConnection` object, as returned by `dbConnect()`.
`query`	SQL Query to server to request table
`roundRealDigits`	Optionally round digits of all doubles. Takes an integer to fill in the `digits`

Value

Tibble of a database table

Creation notes

First created in 2020-12-11 while working in the MARC-KC/CovidDataEntry Repository

Author(s)

Jacob Peterson

Examples

## Not run:  

library(DBI)

con <- connectODBC("<servername>.<databaseName>.<schemaName>")

table <- DBI_getOBDCtable(con, "SELECT * FROM <schemaName>.<tableName>") 

## End(Not run)

MARC-KC/marcR documentation built on June 2, 2022, 9:31 p.m.