BTEQ - LOGON in Teradata

The first command to perform the database operations is .LOGON.

.LOGON generally has four parameters,

1. TDPID
2. User ID
3. Password
4. Acct ID

Syntax:
Enter your logon or BTEQ command:
.LOGON TDPID/User ID
Password: 
***


Message from BTEQ:
*** Logon successfully completed.
*** Teradata Database Release is 12.00.00.10
*** Teradata Database Version is 12.00.00.10
*** Transaction Semantics are BTET.
*** Character Set Name is 'UTF16'.
*** Total elapsed time was 1 second.


BTEQ LOGON elements:
ElementRequirementDescription
tdpid/Optionalthe Teradata Director Program ID
useridRequiredyour user identifier.
passwordRequiredthe password for your userid.
acctidOptionalthe account identifier for your userid.


Note: Omit acctid if you have not been issued one.