tdQuery: Query Teradata Database

Description Usage Arguments Details Value Examples

View source: R/tdQuery.R

Description

Send a query to the Teradata Database and get a data frame back. This call is a wrapper of the sqlQuery function using the global tdConnection property.

Usage

1

Arguments

q

An sql query.

...

dots to pass along to sqlQuery for other attributes

Details

This function allows the user to query the Teradata system without always having to specify the connection. It uses the global connection tdConnection set in tdConnect.

Value

data frame result for row returning queries. "No Data" returned for non row returning queries.

Examples

1
2
3
4
5
6
7
## Not run: 

df <- tdQuery("SELECT * FROM customer")
#returns data frame object with all rows and columns from customer table


## End(Not run)

nonsleepr/teradataR documentation built on May 23, 2019, 9:32 p.m.