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

Basic Teradata® Query Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Basic Teradata Query
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2024-11-15
dita:mapPath
gxl1691484661681.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
psp1479308573013
lifecycle
latest
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.