tdSpool: tdSpool

In tranlm/tdR: Teradata interaction and query package

Description

Queries Teradata for spool use. Can take a JDBC connection object (conn) if provided. If no JDBC connection is provided, then a connection is attempted using the user, and password provided. If none is provided, then tries to locate a connection object (conn) in the global environment.

If a connection profile (e.g. username, password, etc.) is provided, then an attempt is made to connect to Teradata. Once the query is run, the connection is then closed. If a connection object (conn) is provided to the function (or one is found globally), then the connection remains open.

Usage

tdSpool(user = "user", ...)

Arguments

user	Username to grab CPU use from. Defaults to the username used in the Teradata connection.
...	Optional connection settings.

Value

A data.frame object is returned with all of the Teradata spool information.

Examples

## NOT RUN ##
## Connect to default data warehouse and data base
# tdSpool(<username>, <password>)

## Runs query using a separately established connection
# conn = tdConn(<username>, <password>)
# tdSpool(conn=conn)

## Uses same connection, but allows code to find globally
# tdSpool()

tranlm/tdR documentation built on May 31, 2019, 7:45 p.m.