Use the Teradata Visual Explain command line interface to log on to a Teradata Database.
- To connect to Teradata Database, use the following command: VEComp <Logon specification> [-d <qcdname>]
Example Commands for Connecting to Teradata Database
The following table describes commands used to connect to a Teradata Database.
| Example | Command | Description |
|---|---|---|
| 1 |
VEComp -l |
Display the CLIv2 logon dialog box. |
| 2 |
VEComp -l SysA\dbc\dbc |
Use CLIv2to log on to server SysA. |
| 3 |
VEComp -l SysA\dbc\dbc -d qcd |
Use CLIv2 to log on to server SysA database qcd. |
| 4 |
VEComp -c |
Display the ODBC Data source selection dialog box. |
| 5 |
VEComp -c SysA |
Use the ODBC Data Source SysA to log on. |
| 6 |
VEComp -l SysA\dbc\dbc -am td2\xxx |
Use CLIv2 to log on to server SysA. The authentication mechanism is td2. The authentication parameter is xxx. |
| 7 |
VEComp -l SysA\dbc\dbc -am NONE\NONE |
Use CLIv2 to log on to server SysA. Extended security mechanism is not used. |
| 8 |
VEComp -l SysA\dbc\dbc -am td2 |
Use CLIv2 to log on to server SysA. The authentication mechanism is td2. No authentication parameter is used. |
| 9 |
VEComp -l SysA\dbc\dbc -am td2\xxx -scs UTF16 |
Use CLIv2 to log on to source SysA. The authentication mechanism is td2, and xxx is the authentication parameter, using UTF-16 as the session character set. |
| 10 |
VEComp -c SysA\pwd1 -am td2\xxx |
Use ODBC to log on to source SysA. Assumes the DSN is configured with the user name. Connects using td2 as the authentication mechanism and xxx as the authentication parameter. |
| 11 |
VEComp -c SysA\pwd1 -am td2\xxx -scs UTF16 |
Use ODBC to log on to source SysA. Assumes the DSN is configured with the user name. Connects using td2 as the authentication mechanism and xxx as the authentication parameter, using UTF-16 as the session character set. |
| 12 |
VEComp -c SysA\pwd1 -am xxx |
Use ODBC to log on to source SysA. Assumes the DSN is configured with the user name and the authentication mechanism. Connects using xxx as the authentication parameter. |
| 13 |
VEComp -c SysA\user1\pwd1 -am xxx |
Use ODBC to log on to source SysA. Assumes the DSN is configured with the authentication mechanism. Connects using xxx as the authentication parameter. |
| 14 |
VEComp -c SysA\pwd1 -am NONE\NONE |
Use ODBC to log on to server SysA. Assumes the DSN is configured with the user name. No extended security mechanism is used. |
The -am switch is optional and should be used in conjunction with the -l or -c logon switches. It is possible to connect to Teradata Database using the direct user authentication mechanisms without specifying the -am switch. However, to use multiple connections (which are required when using the bulk compare feature or loading multiple online plans), the authentication mechanism must be supplied for all connections or none of the connections. That is, the -am switch must be supplied for all of the connections or not used for any connection.
To use an alternate logon mechanism for one server and not use any alternate logon mechanism for another specific server, the -am switch must be supplied for the specific server as -am NONE\NONE.