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. 
.logoff

➠ Logging off from the current User including exit from Bteq. 
.exit
.quit
  
**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. 
show;

➠ Checking the login user 
.show control

➠ To view Unicode charactes in the resultset. 
.SET SESSION CHARSET "UTF8"

➠ Executing last command 'n' times. 
=3;

**This will execute last command 3 times

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