Description Usage Arguments Details Value See Also Examples
Determines if Teradata table exists. 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.
1 |
table |
String vector of name of table to get column names from. |
... |
Optional connection settings. |
This function looks in the DBC.COLUMNS
table to determine
whether the Teradata table exists.
Returns a boolean indicator of either TRUE
if table exists or
FALSE
if table does not.
tdConn
for connection, tdDisk
for disk usage,
tdSpool
for spool usage, tdCpu
for CPU
usage, and tdJoin
for joining tables.
1 2 3 4 5 6 7 8 9 10 | ## NOT RUN (will also result in errors due to user restrictions) ##
## Runs a quick query based on connection profile
# tdExists("ICDB_PERSON", username=<username>, password=<password>, db="GCA")
## Runs query using a separately established connection
# conn = tdConn(<username>, <password>, db="GCA")
# tdExists("ICDB_PERSON", conn=conn)
## Uses same connection, but allows code to find globally.
# tdExists("ICDB_PERSON")
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.