tdRows: tdRows

In tranlm/tdR: Teradata interaction and query package

Description

Gets the rows in Teradata tables. 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

tdRows(table = NULL, where = "", ...)

Arguments

table	String vector of name of table to get table dimensions from.
where	String statement to subset table with.
...	Optional connection settings.

Value

Returns a the number of Teradata table rows.

See Also

tdConn for connection, tdNames for table names, td for general queries, tdCpu for CPU usage, and tdJoin for joining tables.

Examples

## NOT RUN (will also result in errors due to user restrictions) ##
## Runs a quick query based on connection profile
# tdRows("ICDB_PERSON", username=<username>, password=<password>, db="GCA")

## Runs query using a separately established connection
# conn = tdConn(<username>, <password>, db="GCA")
# tdRows("ICDB_PERSON", conn=conn)

## Uses same connection, but allows code to find globally. 
# tdRows("ICDB_PERSON")

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