tdSpool: tdSpool

Description Usage Arguments Value Examples

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

1
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

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
## 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.