Use the Teradata SET command-line interface to log on to a Teradata Database using either ODBC or CLIv2 connectivity.
-
Use the following command syntax to log on to a Teradata 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 Teradata Database named mytdpid with the user name jeff. tset -l mytdpid\jeff\padres Use CLIv2 to log on to a Teradata Database named mytdpid with the user name jeff and password padres.