Logon in teradata, Logoff in teradata, Run command from file in teradata, execute last command in teradata, run os commands from bteq in teradata, view unicode data in teradata, check last executed command in teradata, check logged in user in teradata, show last executed command in teradata, utf8 characterset in teradata, quit/ exit from teradata, compile procedure in teradata, teradata bteq login, teradata bteq Logon


Teradata Basic Terminal Commands

Logon to Teradata database
.logon tdpid/username,password

Logging off from the current User without exiting from Bteq.

Logging off from the current User including exit from Bteq.
**One of the 2 commands can be used

Executing ddls/dmls/login/compiling macro from file.
.run file="[filename]"

Compiling procedures from file.
.compile file="[filename]"

Checking the last executed command.

Checking the login user
.show control

To view Unicode charactes in the resultset.

Executing last command 'n' times.

**This will execute last command 3 times

Operating System Commands from bteq.
.os [command]
Example 1: .os vi [filename]
Example 2: .os pwd