tdShow: tdShow

In tranlm/tdR: Teradata interaction and query package

Description

Gets the Teradata code used to create the table. 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

tdShow(table = NULL, ...)

Arguments

table	String of name of table to get Teradata code from.
...	Optional connection settings.

Details

Many of the core production tables in Teradata are locked, such that trying to query to show table code will result in Error 3853. This is a part of the user restrictions and can be circumvented by creating a new subset of the table and querying that subset. If the Teradata code is unable to be determined, a value of NA will be returned.

Value

Returns a string vector of the the Teradata code.

See Also

tdConn for connection, tdDisk for disk usage, tdSpool for spool usage, 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
# tdShow("ICDB_PERSON", username=<username>, password=<password>, db="GCA")

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

## Uses same connection, but allows code to find globally. Also used for multiple tables.
# tdShow(c("ICDB_PERSON", "ICDB_PERSON_X"))

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