ODBCRun: Runs a SQL query using ODBC driver

Description Usage Arguments Value Examples

Description

Runs a SQL query in a database using the ODBC driver and returns a resultset. Before hand a DSN has to be created under Control Panel -> Administrative tools.

Usage

1
ODBCRun(query, dsn = "mydsn")

Arguments

query

SQL Query to execute.

dsn

Data source name.

Value

SQL resultset in a dataframe

Examples

1
ODBCRun("SELECT * FROM ALL_TABLES", "myDSN")

neemtreeparrot/deebee documentation built on May 6, 2019, 12:05 a.m.