Logging On - System Emulation Tool

Teradata® System Emulation Tool User Guide

Product
System Emulation Tool
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-19
dita:mapPath
log1544831946868.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2492
lifecycle
previous
Product Category
Teradata Tools and Utilities
Use the Teradata SET command-line interface to log on to the database using either ODBC or CLIv2 connectivity.
  1. Use the following command syntax to log on to the database:
    tset [-c|-l] <DSN_or_tdpid>\<username>\<password>
         [-am <Authentication Mechanism>\<Authentication Parameter>]
         [-scs <Session characterset>]
    When only the log-on switch is specified in the command, the application remains open after a connection is established regardless of the xapp switch. The following examples demonstrate ways to log on from the command line.
    Syntax Example Description
    tset -c mydsn Use ODBC to log on to the data source named mydsn. If the complete log-on information is not available in the DSN, the Teradata Database dialog box appears.
    tset -c mydsn\jeff\padres Use ODBC to log on to the data source named mydsn with the user name jeff and password padres.
    tset -c mydsn\padres Use ODBC to log on to the data source named mydsn with the password padres. If the user name is not available in the DSN, the Teradata Database dialog box appears.
    tset -l mytdpid\jeff Display the Connect to Teradata Database dialog box and wait for a password. Then, use CLIv2 to connect to a database system named mytdpid with the user name jeff.
    tset -l mytdpid\jeff\padres Use CLIv2 to log on to a database system named mytdpid with the user name jeff and password padres.