Log On to a Database in Interactive Mode | Basic Teradata Query - Logging On in Interactive Mode - Basic Teradata Query

Basic Teradata® Query Reference

Product
Basic Teradata Query
Release Number
17.00
Published
December 2020
Language
English (United States)
Last Update
2020-12-12
dita:mapPath
zqt1544831938740.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities
Step Action Result or Explanation
1 Enter the LOGON command as follows:

.LOGON tdpid/userid,, 'acctid'

BTEQ clears the input area and prompts the user for a valid password.
Omit acctid if one has not been issued. If userid is omitted, BTEQ prompts the user to enter it.
2 Enter the related database user's password:

Password: ##########

BTEQ does not display the password. If the logon is successful, BTEQ displays the successful logon message.